Forum Discussion

sjj1987's avatar
sjj1987
Copper Contributor
Mar 14, 2024
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 c...
Charting
Formulas and Functions
  • m_tarler's avatar
    m_tarler
    Mar 14, 2024
    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?
m_tarler's avatar
m_tarler
Bronze Contributor
Mar 14, 2024
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?
  • sjj1987's avatar
    sjj1987
    Copper Contributor
    Mar 14, 2024
    It always helps with another set of eyes! Thank you very much for your help; this fixed my issue.

Resources