Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Cell Change Color - Need Help | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |