Conditional Formatting for an entire row or column?
 

I would like to turn all cells a Fill color (e.g., Red) based on the value in
the first column of that row.

Conditional Formatting for an entire row or column?
 

Highlight row
Conditional formatting
Change drop down to Formula Is
=$A1=yourvalue ... and choose your font to be red

This is assuming the first column is A

Hope this helps.
--
John C


"quinnj" wrote:

I would like to turn all cells a Fill color (e.g., Red) based on the value in
the first column of that row.

Conditional Formatting for an entire row or column?
 

quinnj wrote:
I would like to turn all cells a Fill color (e.g., Red) based on the value in
the first column of that row.

Use an absolute reference for the column. For data in row 1 starting in column A:

=IF($A1="your value",1,0)

Copy across as needed.

Conditional Formatting for an entire row or column?
 

You don't need the IF statement... see my post above.
--
John C


"Glenn" wrote:

quinnj wrote:
I would like to turn all cells a Fill color (e.g., Red) based on the value in
the first column of that row.

Use an absolute reference for the column. For data in row 1 starting in column A:

=IF($A1="your value",1,0)

Copy across as needed.

Conditional Formatting for an entire row or column?
 

John C wrote:
You don't need the IF statement... see my post above.

Realized that right after I sent mine...and saw yours!