Related:
- Conditional formatting
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
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
