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
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?
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:
- Conditional Formatting Excel 2013 based on content in other cell
- Need for speed: most wanted 2005 downloadable content - Download - Racing
- Summertime saga downloadable content - Download - Adult games
- Efootball 2022 downloadable content - Download - Sports
- Fifa 23 downloadable content - Download - Sports
- Microsoft office 2013 free download - Download - Office suites
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jan 31, 2017 at 11:51 AM
Jan 31, 2017 at 11:51 AM