Can I change background colors based on criteria from another cel.
 

I need to use conditional formating on a group of cells where as a certain
point needs to reached in another cell for the condition to be true.
Example: IF (B8<10), I need the background in (C12) to be blue, otherwise
the background for the cell has no coding for a background color.

Can I change background colors based on criteria from anothercel.
 

if cell B8 is less then 10, cell C12 to be colored as blue

if cell B8 is blank then also cell C12 to be colored ?

Conditional format | condition 1 : formula is : =AND(B$8<10,B$8<"") |
choose the color | ok



On Feb 8, 11:50*pm, WavMaster
wrote:
I need to use conditional formating on a group of cells where as a certain
point needs to reached in another cell for the condition to be true.
Example: IF (B8<10), I need the background in (C12) to be blue, otherwise
the background for the cell has no coding for a background color.

Can I change background colors based on criteria from anothercel.
 

On Feb 8, 9:50*pm, WavMaster
wrote:
I need to use conditional formating on a group of cells where as a certain
point needs to reached in another cell for the condition to be true.
Example: IF (B8<10), I need the background in (C12) to be blue, otherwise
the background for the cell has no coding for a background color.


Have a look at the following link:
http://www.contextures.com/xlCondFormat02.html