Conditional Formatting

  • Thread starter Thread starter John
  • Start date Start date
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
 
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
 
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")
 
Back
Top