Conditional formatting
Solved/Closed
CrazieB317
TrowaD
- Posts
- 2
- Registration date
- Monday April 8, 2013
- Status
- Member
- Last seen
- April 8, 2013
TrowaD
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Related:
- Conditional formatting
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Copy conditional formatting from one row to another ✓ - Forum - Excel
- If cell contains date then conditional format - Guide
3 replies
TrowaD
Apr 8, 2013 at 11:17 AM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Apr 8, 2013 at 11:17 AM
Hi CrazieB317,
You don't need conditional formatting for that, just a formula:
in cell C3:
=IF(D3="EEE",E2,IF(D3="FFF",F2,G2))
Best regards,
Trowa
You don't need conditional formatting for that, just a formula:
in cell C3:
=IF(D3="EEE",E2,IF(D3="FFF",F2,G2))
Best regards,
Trowa
CrazieB317
Apr 8, 2013 at 12:01 PM
- Posts
- 2
- Registration date
- Monday April 8, 2013
- Status
- Member
- Last seen
- April 8, 2013
Apr 8, 2013 at 12:01 PM
Thanks! I thought I tried that formula earlier but I guess I was entereing something wrong!
TrowaD
Apr 8, 2013 at 12:03 PM
- Posts
- 2880
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- May 2, 2022
Apr 8, 2013 at 12:03 PM
Glad I could help.