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

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.

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.

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.
>

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

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