Conditional formatting one cell based on another excel 2016

Closed
Report
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
Hello,

I want to conditionally format one cell in a row based on another cell in the row. i.e. If cell F1 has a value greater than 2009 I want cell A1 to turn green. Otherwise no formatting.
I want to do this right down a large spreadsheet.

Thanks
Katherine

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi kd,

Conditional formatting formula:
=$F1>2009

Applied range:
=$A:$A

Best regards,
Trowa
0