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
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