Previous Topic Next Topic

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

Related:

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

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses