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

[WavMaster]

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.

 

[muddan madhu]

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

 

[Rasoul Khoshravan]

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