Excel Formatting

[phalls]

New to Excel. Thanks in advance for any help!

I would like to format a group of cells based on the text value on another
cell.

Ex: If A1= Abc, then B1, C1, and D1 would change to a color, without
effecting their formulas.

It seems like a no brainer, but I'm stumped.

 

[Per Jessen]

Hi

You need conditional formatting.

Select B1 and goto Format > Conditional Formatting > Select "Formula is" >
In next field enter : =$A1="Abc" > Format as desired > OK

Use the format painter to apply conditional formatting on C11

Hopes this helps.

 

[Max]

You can apply conditional formatting to the range
which is all dependent on the value in A1

Select B1:C,
Click Formatting > Conditional Formatting
Under Condition 1, Formula is: =$A1="Abc"
Click Format > Format fill to taste > OK out
Test it out ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik

 

[Max]

Typo, it should read:

Select B11,

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---

 

[Shane Devenshire]

Hi,

And if you are using 2007:

1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=$A1="Abc"
5. Click the Format button and choose a format.
6. Click OK twice

Note if you are worried about the difference between Abc and ABC then
=EXACT(SA1,"Abc")