Conditional Formatting: Shading???

  • Thread starter Thread starter mcr1
  • Start date Start date
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
 
Hi
- select A4:A8
- goto the conditional format dialog
- enter the following formula
=$A$1=91
- choose your format
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
Excel 2007: cell shading (not conditional formatting) 1
Conditional Formatting by percent range 2
Conditional Formatting 4
Conditional Formatting 2
Conditional Format & Default Format Help 1
Conditional Formatting Formula 6
conditional formatting 1

Back
Top