Automatically color fill if a value is present

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
 
L

Larry Kahm

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
 
B

Bob I

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...
 
L

Larry Kahm

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
 
B

Bob I

The conditional formatting is "set" on the cells that will be changed,
you can't make another cells change color.
 
R

RagDyer

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.
 
Top