Hey Guys,
I am trying to write a macro That would evaluate the following and make a conditional formatting change:
If cell c2 = cell c1(which contains the now function) and cell b2 = cell c2 then change cell color to (whatever)
also i'm trying to write a macro to change to a certain color when there is nothing in two cells:
if cell a2 = blank and cell d2 = blank then make them pink.
oh and naturally these would apply to a range of cells.
I appreciate any help.
Thanks,
Ritz
Bookmarks