Conditional formatting-color a cell based on the value of anothe
Closed
wharrington
TrowaD
- Posts
- 1
- Registration date
- Friday October 10, 2014
- Status
- Member
- Last seen
- October 10, 2014
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Conditional formatting-color a cell based on the value of anothe
- Conditional format to highlight cell based on date ✓ - Forum - Excel
- Conditional Formatting a single cell based on another range ✓ - Forum - Excel
- Excel count conditional formatting color cells - Forum - Excel
- Excel copy conditional formatting color to another cell ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
1 reply
TrowaD
Oct 14, 2014 at 11:04 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Oct 14, 2014 at 11:04 AM
Hi Wharrington,
Use conditional formatting, choose to use a formula:
=S1="Not met" -change format to red.
=S1="Met" -change format to green.
Apply this to the full range S1:S100.
Best regards,
Trowa
Use conditional formatting, choose to use a formula:
=S1="Not met" -change format to red.
=S1="Met" -change format to green.
Apply this to the full range S1:S100.
Best regards,
Trowa