How do I highlight certain rows when a condition is met like today is pink, tomorrow is blue background respectively?
Example:
when b2 fall on today() a2..l2 cells is in pink and b5 falls today()+1 a5..l5 cells is in blue background.
I try the Format/Conditonal formatting but it only does one cell only.
Any help will be appreciated.
silver
Example:
when b2 fall on today() a2..l2 cells is in pink and b5 falls today()+1 a5..l5 cells is in blue background.
I try the Format/Conditonal formatting but it only does one cell only.
Any help will be appreciated.
silver