Varying Background Color Question
Posted by Jon Burry on May 28, 2001 7:19 AM
Hey everyone, looking for a little help here. I'm trying to set up Excel to change the background color of a cell depending on the value of another cell. Say we have cells A1-A10 with a light blue fill when the value of all of those cells is empty, but, then, the data changes in cell A3 changes to contain the number 2, or a, or whatever, I want the cell then to automatically change the background color of all these cells from light blue, to no fill whatsoever. I know this can be done, but I have no idea how to go about it. If anyone could help me I would greatly appreciate it.
Posted by Dave Hawley on May 28, 2001 7:49 AM
Hi Jon
You could probably use "Conditional Formatting" to do this. This can be found under Format.
Select cells A1:A10
Go to Format>Conditional formatting.
select "Formuala is"
Then type =$A$3<>""
Click Format and then Patterns-No color
Click Ok, then Ok again
Dave
OzGrid Business Applications
Posted by Aladin Akyurek on May 28, 2001 7:53 AM
Jon
Activate cell A1, activate Format|Conditional Formatting, Choose "Formula Is". Type as formula
=ISBLANK(A1) [ not $A$1, just A1 ]
Click on Format, Choose color light blue on Patterns tab. Finish.
While in A1, activate the icon for Format Painter, then select all the rest of the cells (A2:A10 in your case).
Aladin
