Conditional Formatting
Closed
Badgermd163
-
26 Sep 2008 à 04:20
Ivan-hoe Posts 433 Registration date Saturday 16 February 2008 Status Member Last seen 17 October 2008 - 26 Sep 2008 à 06:00
Ivan-hoe Posts 433 Registration date Saturday 16 February 2008 Status Member Last seen 17 October 2008 - 26 Sep 2008 à 06:00
Related:
- Conditional Formatting
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- Excel conditional formatting dates overdue ✓ - Excel Forum
- Formatting windows 7 - Guide
- Conditional formatting if cell contains text ✓ - Excel Forum
1 response
Ivan-hoe
Posts
433
Registration date
Saturday 16 February 2008
Status
Member
Last seen
17 October 2008
110
26 Sep 2008 à 06:00
26 Sep 2008 à 06:00
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.