Conditional formatting

[Caroline]

Hello,
Using Excel 2007, I want cells in a column to be formatted according to
cells in a different column and I want it to work so that if A1="text", B1
gets formatted; if A2="text" (same text), B2 gets formatted, etc...
I use the formula A:A="text" applied to B:B and even $A:$A="text" applied to
$B:$B, but neither work. It only works for one cell at a time (if I apply the
formula to B1 using A1). My column is rather big, I do not want to repeat the
formula all the way down, there's gotta be a way
Any help would be appreciated, thanks.
Caroline

 

[ShaneDevenshire]

Hi,

2007:
1. Select B1:B1000 or what ever (note the active cell is B1, meaning you
select from B1)
2. Choose Home, Conditional Formatting, New Rule
3. Pick Use a formula to determine which cells to format
4. In the Format values where this formula is true, enter the formula:
=A1="text"
5. Click the Format button and on the Fill tab choose a color
6. Click OK twice.

If this helps, please click the Yes button.