Conditional Formatting Excel 2013 based on content in other cell [Closed]

Report
-
Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
-
Hello,

I have a spreadsheet with columns that have targets and results next to each other. If the target is reached (=) or exceeded (>) I want the result font to be green. Conversely if the result is not reached (<) I want the result font to be red.

I've been searching and while there are a lot of formulas that deal with changing cell colours or font colours based on a number of set thing, but not based on whether the other cell content is =/> or < than the cell content you want to change.

Can this be done?

1 reply

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
Hi Paul,

Formula for green font:
=$B2>=$A2
Formula for red font:
=$B2<$A2

May this screengrab give you a visual assist:


Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!