Cell color based on different cell value

B

Brett Patterson

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!!
 
B

Brett Patterson

Thanks for your site. It does answer my question; however, after I posted I
answered my own question. I basically used a forumla and said:

Formula is: =$H1<>""
Color cell BLUE

Easy enough right? Thanks for the help though. Your site did answer my
question.
------------------------
Brett Patterson
UMBC EHS Management Major


Anne Troy said:
Try this, Brett:
http://www.officearticles.com/excel/conditional_formatting_with_formulas_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com
Click to expand...
 
Top