Hi guys & gals.

Here's what I'm trying to do. I knew the answer once, but forgot, so I'm
asking for some help.

Basically, I want to check to see if a cell has a value in it. If it does
(i.e. $A1!="") then I want to color it white (as in "in Progress"), and if
not (i.e. $A1="") then it should be blue (as in "Closed").

Basically, the cells in column A should be colored based upon the value of
it's corresponding cell in row G.

A | B | C | D | E | F | G |
1 | white | | | | | | |
2 | blue | | | | | | today |

I hope that is understandable. And thanks for the help!!
------------------------
Brett Patterson
UMBC EHS Management Major