Forum Discussion

Pat_Forster's avatar
Pat_Forster
Copper Contributor
Jul 23, 2021
Solved

Trouble with Conditional formatting

Let me try and explain what I am trying to do here. I have a series of columns with the date4 for the Monday of every week. This goes out for 2 years. I am listing electronic components that have different lead-times. I want the color of the dates to change when the date exceeds today's date plus the lead-time number.

 

I am trying to use the week number plus the lead-time number to change the color of a cell

I can enter this formula into a cell and it resolves correctly:

=IF(WEEKNUM(E8)>(WEEKNUM($A$1)+$B9),"","OK")

 

However if I enter this same formula into the conditional formatting it does nothing. It does not resolve at all. Of course under the formula conditional formatting is

"IF(WEEKNUM(E8)>(WEEKNUM($A$1)+$B9)"

 

Am I missing something here?

 

Thanks,

Pat 

Resources