Conditional Formatting

J

John

How can I format a range of cells in a row, based on
the conditional format of a single cell in the same row.

I am able to get the single cell to change, but I would like the other cells
in the range to change colors as well.

Thanks,

John
 
F

Frank Kabel

Hi John
1. Highlight the entire row (e.g. row 1)
2. Goto conditional format
3. You have to enter the condition with an absolute reference. e.g.
=$A$1="text"
this will change all cells in row 1 if A1 contains "text"

HTH
Frank
 
D

Dave Peterson

Just to add to Frank's suggestion:

If you select a range with multiple rows, you can set the conditional formatting
for all of the rows by using a formula like:

=$a1="text"

Assumes that the activecell is in row 1 (change that 1 to match the activecell's
row.)

(notice that I have one less $ in my formula. Frank used: =$A$1="text")
 
Top