Conditional Formatting
Closed
Badgermd163
-
Sep 26, 2008 at 04:20 AM
Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 - Sep 26, 2008 at 06:00 AM
Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 - Sep 26, 2008 at 06:00 AM
Related:
- Conditional Formatting
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
1 response
Ivan-hoe
Posts
433
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
110
Sep 26, 2008 at 06:00 AM
Sep 26, 2008 at 06:00 AM
Hello Badger,
Actually you need only 2 conditions, since you use only two different formattings : green or red.
No VBA needed, use a formula in your conditionnal formatting instead.
Condition 1: =OR(A1="no";A1="?") ---> red colour
Condition 2: =OR(A1="/";A1="yes";A1="#N/A") --> green colour
Ivan.
Actually you need only 2 conditions, since you use only two different formattings : green or red.
No VBA needed, use a formula in your conditionnal formatting instead.
Condition 1: =OR(A1="no";A1="?") ---> red colour
Condition 2: =OR(A1="/";A1="yes";A1="#N/A") --> green colour
Ivan.