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