SOLVED

Trouble with Conditional formatting

Copper Contributor

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 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Pat_Forster 

Use

 

=WEEKNUM(E8)>WEEKNUM($A$1)+$B9

 

 

@Hans Vogelaar Thank you for your input. I was able to get this operating the way that I want.

 

Thanks for your help. 

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@Pat_Forster 

Use

 

=WEEKNUM(E8)>WEEKNUM($A$1)+$B9

 

 

View solution in original post