Q
quinnj
I would like to turn all cells a Fill color (e.g., Red) based on the value in
the first column of that row.
the first column of that row.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John C
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.
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.
G
Glenn
quinnj said: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.
J
John C
You don't need the IF statement... see my post above.
G
Glenn
John said:You don't need the IF statement... see my post above.
Realized that right after I sent mine...and saw yours!