3rd Conditional format
Hello
(Conditional formating entire row)
Condition 1 = formula is =$K131=€ťShipped and Invoiced€ť format color green
Condition 2 = formula is =$K131<€ť€ť format in yellow. The above condition
works fine now I need to add a third condition €“
Column O has a date - if the date on cell O131 workday (example
todays date is June 2 so if O131 = 5/30/08 - We always report one business
day behind) ) then highlight the row in blue BUT
Everything that is €śShipped and invoiced€ť also has the same date as of
5/30/08 and that needs to color in green
Do I need a macro for this?
Thanks in advance
|