How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,843
- Office Version
- 2010
- Platform
- Windows
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
How can I sort the following out please?
<o> </o>
M11:N11 are highlight by CF because F11:H11 are not = to 12… So IF B11 is blank I don’t want my CF to work…
<o> </o>
Therefore, this is the original formula I placed in the CF… =SUM($F9:$H9)<>12 so for my solution I need to add do nothing if B9 is blank… How would I do that please?
How can I sort the following out please?
<o> </o>
M11:N11 are highlight by CF because F11:H11 are not = to 12… So IF B11 is blank I don’t want my CF to work…
<o> </o>
Therefore, this is the original formula I placed in the CF… =SUM($F9:$H9)<>12 so for my solution I need to add do nothing if B9 is blank… How would I do that please?
Excel Workbook | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | |||
9 | 5, 1, 6 | 1 | 1 | 5 | 1 | 6 | 1.01 | 1 | 5, 1, 6 | 1 | |||||
10 | 3, 5, 3 | 1 | 2 | 3 | 5 | 3 | 2.02 | 2 | 3, 5, 3 | 1 | |||||
11 | |||||||||||||||
Sheet1 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
M9 | 1. / Formula is =SUM($F9:$H9)<>12 | Abc | ||
N9 | 1. / Formula is =SUM($F9:$H9)<>12 | Abc | ||
M10 | 1. / Formula is =SUM($F10:$H10)<>12 | Abc | ||
N10 | 1. / Formula is =SUM($F10:$H10)<>12 | Abc | ||
M11 | 1. / Formula is =SUM($F11:$H11)<>12 | Abc | ||
N11 | 1. / Formula is =SUM($F11:$H11)<>12 | Abc |