Forum Discussion
Unknown error causing conditional formatting inaccuracy
Hi I have noticed that cell J14 is not formatting correctly based on the date in H14. It should be red but is instead green. The purpose of the conditional formatting in column J is to show in ...
If you set he horizontal alignment of column H to General, you'll see that most values are right-aligned, but H14 is left-aligned. This indicates that H14 is not a valid date.
Why? September has only 30 days, not 31, so 31/09/2023 does not exist.
If you change H14 to 30/09/2023, J14 will become red.
- Thank you!!! 🙂
