Conditional Formatting: Shading???

M

mcr1

I am back again. In cell A1, I have a drop down with 2 #s in it, 91 an
135. If cell a1 has 91 selected, I want cells A4:48 to be shaded grey
but I cannot seem to figure out the formula to put in the Conditiona
formatting dialogue box. Anyone know the answer? Thanks as well fo
all of your good help.


Miles Ree
 
F

Frank Kabel

Hi
- select A4:A8
- goto the conditional format dialog
- enter the following formula
=$A$1=91
- choose your format
 
Top