Conditional Formatting

[Thedda]

I'm trying to set up a conditional formatting for the quantities. So if Cell E7 had BLANK and the date in K7 is <= today() and qty in K7 is <> 0 then color the cell RED.

If Cell E7 had BLANK and the date in K7 is = today() and qty in K7 <> 0 then color the cell YELLOW.

If Cell E7 had BLANK and the date in K7 is > today() and qty in K7 <> 0 then color the cell GREEN.

I've attached the spreadsheet for easier reading. Appreciate any help I can get on this.

 

[HaHoBe]

Hi, Thedda,

hope I got it solved.

Ciao,
Holger

 

[willamtarker]

You already got the solution. Do you want any other help then please feel free to contact me as I think I can solve almost every problem in Excel...

 

[Thedda]

got pulled off this project temporary. wanted to let you know the Conditional format works great.

Thank you very much.