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