DJFANDANGO
Board Regular
- Joined
- Mar 31, 2016
- Messages
- 113
- Office Version
- 365
- Platform
- Windows
Good afternoon all,
another brain freeze from me...
I'm trying to get col 6, 7 etc to be blank if there is nothing in that column, I've tried conditional formatting to no avail...
Please help this simpleton get this (whats probably going to be a VERY simple formula)
Thanks in advance...
another brain freeze from me...
I'm trying to get col 6, 7 etc to be blank if there is nothing in that column, I've tried conditional formatting to no avail...
Please help this simpleton get this (whats probably going to be a VERY simple formula)
Thanks in advance...
Steps to Stevie HOME.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||
8 | Player 1 | 6961 | 11159 | 11045 | 16443 | 6129 | ||||
9 | Player 2 | 15005 | 6251 | 7009 | 11251 | 8010 | ||||
10 | Player 3 | 10499 | 10385 | 11208 | 12134 | 8809 | ||||
11 | Player 4 | 14439 | 5603 | 10294 | 11395 | 13101 | ||||
12 | Player 5 | 13462 | 10240 | 13039 | 13542 | 13508 | ||||
13 | Player 6 | 10253 | 16990 | 10845 | 18866 | 15651 | ||||
14 | Total Daily | 70619 | 60628 | 63440 | 83631 | 65208 | ||||
15 | Total Combined | 70619 | 131247 | 194687 | 278318 | 343526 | ||||
16 | Previous Challenge | 71300 | 71631 | 82175 | 81478 | 76328 | ||||
17 | Less Than Previous | YES | YES | YES | NO | YES | NO | NO | ||
18 | How many Under | -681 | -11003 | -18735 | -11120 | |||||
19 | How Many Over | 2153 | ||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B14:H14 | B14 | =IF(B8<>"",SUM(B8:B13),"") |
B15 | B15 | =SUM(B8:B13) |
C15:F15 | C15 | =SUM(C8:C13)+B15 |
G15:H15 | G15 | =IF(G8<>"",SUM(G8:G13)+F15,"") |
B16:F16 | B16 | ='Steps to Islay'!B$10 |
G16:H16 | G16 | =IF(G15<>"",'Steps to Islay'!G$10,"") |
B17:H17 | B17 | =IF(B14<B16,"YES","NO") |
B18:H18 | B18 | =IF(B14<B16,B14-B16,"") |
B19:H19 | B19 | =IF(B14>B16,B14-B16,"") |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
B17:FG17 | Cell Value | contains "NO" | text | NO |
B17:FG17 | Cell Value | contains "YES" | text | NO |