IF statement to make cells change shading

R

RobertM

Is there any way that I can put a conditional format in an IF statement when
if it is true certain cells change shading?
 
G

Gary''s Student

Absolutely!

You can put the IF in the conditional format using the:
Formula Is option
 
R

RobertM

I'm interested in the conditonal formatting change the shading of more than
one cell. Any suggestions?
 
G

Gord Dibben

Select the cells to CF and go from there.

e.g. you want A1:A12 to change color when B1 is a certain value like 123456

Select A1:A12 and CF>Formula is: =$B$2=123456

Pick a color and OK your way out.


Gord Dibben MS Excel MVP
 
Top