Forum Discussion
esmefarrow
Oct 21, 2026Occasional Reader
Conditional formatting
I'm making a rule to Highlight cells in Column AZ when the value is lower than Adjacent cells in Column P.
For the most part it works except for two cells in AZ (1 shown as an example) that are higher than P but are being picked up by the conditional formatting. The two cells I'm focusing on here are P14 (£0.27) and AZ14 (£0.43).
£0.43 should not be being highlighted pink as it isn't lower than £0.27. This has to be something obvious but I have looked at it too long. Please help if you can :)
1 Reply
- Riny_van_EekelenPlatinum Contributor