Cell color based on different cell value
 

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

Try this, Brett:
http://www.officearticles.com/excel/...ft_ excel.htm
************
Anne Troy
www.OfficeArticles.com

"Brett Patterson" wrote in
message ...
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

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" wrote:

Try this, Brett:
http://www.officearticles.com/excel/...ft_ excel.htm
************
Anne Troy
www.OfficeArticles.com

"Brett Patterson" wrote in
message ...
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