Automatically color fill if a value is present

  • Thread starter Thread starter Larry Kahm
  • Start date Start date
L

Larry Kahm

Simple thing, I'm sure, but I am stumped.

If there is a value in cell H2, I want cell A2 to be light green; otherwise
there should be no change to the background color.

How can this be formulated?

Thanks!

Larry
 
Thanks, I did run across that before posting.

But that funtion seems only to work in the current cell - meaning I can
change the background of H2 if H2 has a value (there doesn't appear to be
any way to handle "not blank") and I can't see how to change the color of
A2.

Larry
 
try "Formula is" instead of "Cell value is"

Larry said:
Thanks, I did run across that before posting.

But that funtion seems only to work in the current cell - meaning I can
change the background of H2 if H2 has a value (there doesn't appear to be
any way to handle "not blank") and I can't see how to change the color of
A2.

Larry
Click to expand...
 
Better (and didn't even notice the drop-down, so shame on me), but I still
don't see any way to change the color of another column's cells...

Larry
 
The conditional formatting is "set" on the cells that will be changed,
you can't make another cells change color.
 
You *CAN* change the color of *another* cell by simply applying conditional
formatting to *that* cell, and have *that* cell reference your original
cell!

Select A2, then,
<Format> <Conditional Format>
Change "Cell Value Is" to "Formula Is",
And enter this formula:

=H2<>""

Then, click of format and chose whatever you like,
Then <OK> <OK>

Now, any time H2 is *not* blank, A2 will change to the format you chose.
 
Back
Top