W
Wanna Learn
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
today’s 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
(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
today’s 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