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
- After formatting computer what's next ✓ - Laptop Forum
- Conditional formatting 3 color scale percentages ✓ - 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.