IF statement to make cells change shading
 

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

IF statement to make cells change shading
 

Absolutely!

You can put the IF in the conditional format using the:
Formula Is option
--
Gary''s Student - gsnu200724


"RobertM" wrote:

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

IF statement to make cells change shading
 

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

"Gary''s Student" wrote:

Absolutely!

You can put the IF in the conditional format using the:
Formula Is option
--
Gary''s Student - gsnu200724


"RobertM" wrote:

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

IF statement to make cells change shading
 

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 CFFormula is: =$B$2=123456

Pick a color and OK your way out.


Gord Dibben MS Excel MVP

On Fri, 25 May 2007 11:02:00 -0700, RobertM
wrote:

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

"Gary''s Student" wrote:

Absolutely!

You can put the IF in the conditional format using the:
Formula Is option
--
Gary''s Student - gsnu200724


"RobertM" wrote:

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