cell shading

[greg7468]

Hello all,
I am looking for a way of automatically shading a range of cells takin
the value from another cell.
i.e. If A1 has the value of 25 in it is there a way of thi
automatically shading say B1:B25.
Thanks in advance.

Greg

 

[Rollin_Again]

Select the range of cells that you want the conditional formatting t
apply to (B1:B25) and then click *FORMAT --> CONDITIONAL FORMATTING.*
Next change the "Condition 1" drop down selection to read *FORMULA IS*
Enter the formula below into the formula textbox and then click th
format button, select the patterns tab and select what color format yo
would like applied to yoru range of cells if the formula you entered i
true.

=IF($A$1=25,TRUE,FALSE



Rolli

 

[Guest]

The easiest way to do this is by using your "formatting"
toolbar. To access it click anywhere in the toolbar and
make sure formatting is turned on.
ONce this is on select your cell that has the correct
shading, then highlight your cells you want to copy to
and choose the cell chading button to acheive the same
shading with.
Ed

 

[Paul B]

Greg, have a look at Conditional Formatting in help, if you need anymore
help with it just post back

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **

 

[John P]

Chip Pearsons offering may help.
http://www.cpearson.com/excel/banding.htm

Cheers

John
NYks UK