Solved Conditional fortmating

January 9, 2012 at 11:28:15
Specs: Windows XP
I am trying to apply a conditional format for column G for current date and only if column H says WIP... Anyone help?

See More: Conditional fortmating

Report •

January 9, 2012 at 11:37:11
✔ Best Answer
Select all of the cells in Column G that you want to apply the formatting to, e.g. G2:G10

The CF formula/rule to use is:


This will apply the CF to each cell individually.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

January 10, 2012 at 05:41:39
Thanks, that workrd perfectly!

Report •

Related Solutions

Ask Question