Forum Discussion
Solved
Conditional Formatting error
I am trying to work out how fix the end date of my conditional formatting. The start dates are fine, but the end dates haven't registered. I have highlighted the dates I am currently using, and the conditional formatting formulas.
Assistance is appreciated. Thank you.
- assuming row 6 is actual dates then you should just use:
=(G$6>=$B8)*(G$6<=$C8)
I think the main problem is you had G$5 instead of 6 and maybe those 'dates' in row 5 are actually text?
2 Replies
- assuming row 6 is actual dates then you should just use:
=(G$6>=$B8)*(G$6<=$C8)
I think the main problem is you had G$5 instead of 6 and maybe those 'dates' in row 5 are actually text?- It always helps with another set of eyes! Thank you very much for your help; this fixed my issue.
