Conditional Formatting Excel 2013 based on content in other cell

Closed
Paul Davids - Jan 29, 2017 at 07:58 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 31, 2017 at 11:51 AM
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?

Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jan 31, 2017 at 11:51 AM
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