Conditional formatting
Solved/Closed
CrazieB317
Posts
2
Registration date
Monday April 8, 2013
Status
Member
Last seen
April 8, 2013
-
Apr 8, 2013 at 10:59 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 8, 2013 at 12:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 8, 2013 at 12:03 PM
Related:
- Conditional formatting
- How to clear formatting in excel - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Phone formatting software for pc - Download - File management
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 8, 2013 at 11:17 AM
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
Posts
2
Registration date
Monday April 8, 2013
Status
Member
Last seen
April 8, 2013
Apr 8, 2013 at 12:01 PM
Apr 8, 2013 at 12:01 PM
Thanks! I thought I tried that formula earlier but I guess I was entereing something wrong!
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 8, 2013 at 12:03 PM
Apr 8, 2013 at 12:03 PM
Glad I could help.