Conditional Formatting on adjacent cells

[ThatDamnRedhead]

Hey,
I am wondering is there a way to make Excel 2007 apply conditional formatting to one or two cells to the left/right of the target cell?

Thanks

[ChemistB]

Yes, Let's say you want A1:A20 and B1:B20 to turn red if C1:C20 has a number in it.
Select A1:B20 and Conditional Formatting>New Rule> Using Formula

=ISNUMBER($C1) When you put a number in C5, A5 and B5 will turn red (or however you format it). Does that work for you?

[ThatDamnRedhead]

That should work, but I want them to change different colors for different text, as your example would state, would be in column C. I am comparing two weeks ranks for various terms, so Column A would have this week, B would have last week, and C ill say "decreased" "increased" "No change" etc... So I think you have a good direction with the isnumber... is there a way of determining certain text instead of a number?

[ChemistB]

Yes, you'll need to set up different rules for different text, i.e. red for decreased, green for increased, etc.
Proceed as above except
=$C1="increased"
Make sense?

[ThatDamnRedhead]

WORKS! Thank you!