Related:
- Conditional formatting
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Excel conditional formatting based on date - Guide
1 response
Let's say the row with yes and no's has the range of A1:J1.
Then put in K1 the following formula: =SUM(IF(A1:J1="no",1,0)).
Confirm this formula by hitting Ctrl+Shift+Enter.
This formula counts how many no's there are in the range A1:J1.
If the result is greater then 0 there is a no in the range.
If the result is 0 then a no doesn't exist in the range.
Use this in conditional formatting:
Condition 1: Formula is: K1>0: apply color red.
Condition 2: Formula is: K1=0: apply color green.
Note that you can put the formula in any cell and if you don't wish to see the result make the text color white.
Best regards,
Trowa
Then put in K1 the following formula: =SUM(IF(A1:J1="no",1,0)).
Confirm this formula by hitting Ctrl+Shift+Enter.
This formula counts how many no's there are in the range A1:J1.
If the result is greater then 0 there is a no in the range.
If the result is 0 then a no doesn't exist in the range.
Use this in conditional formatting:
Condition 1: Formula is: K1>0: apply color red.
Condition 2: Formula is: K1=0: apply color green.
Note that you can put the formula in any cell and if you don't wish to see the result make the text color white.
Best regards,
Trowa