Conditional formatting one cell based on another excel 2016

Closed

kd - Mar 20, 2016 at 09:43 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Mar 21, 2016 at 12:43 PM

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

Conditional formatting one cell based on another excel 2016
Excel conditional formatting based on date - Guide
Excel clear formatting - Guide
Ms office 2016 free download - Download - Office suites
How to copy data from one excel sheet to another - Guide
Conditional formatting based on another cell text - Excel Forum

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
Mar 21, 2016 at 12:43 PM

Hi kd,

Conditional formatting formula:
=$F1>2009

Applied range:
=$A:$A

Best regards,
Trowa

Similar discussions

How to use conditional format based on text?

help me to add particular cells

Highlight cell if another cell contains specific text

Clear cell contents based on value of another cell range using VBA

Return Seq Values Until Blank value then return different set of seq values

Similar discussions

Subscribe To Our Newsletter!