Spreadsheet: 874647d1721211358-im-struggling-with-a-conditional-formatting-formula-excelformumexample
Sheet: Sheet1

Client Parent Name | Client Code | Client Name | Client Dept | Client Partner | Manager | Personal Tax Manager | TIS Service | Treat as a Group | Director of | Partner of | Spouse is | Company Sec of | Assignments | 2023 | Type | Trading Status | Deceased ? | Live client / No longer acting ? | Pensions Received | Employment Payments from P60 | Business Tax Turnover | Land & Property Rental | Total Self Employed | Company Turnover | Insurance Cover If Required
Parent Test 1 | TEST1 | Test Company Ltd | Small Business Team | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Trading | Not applicable | Live record |  |  |  |  |  | 15600 | Ltd Co/LLP/PS up to £250k
Parent Test 1 | TEST2 | [NAME] | Small Business Team | [NAME] | [NAME] | [NAME] |  |  | TEST1 | TEST 72 |  |  |  | Y | Individual |  | No | Live record | 2565 | 32077 | 0 | 0 | 0 |  | DNI | *both TEST1 and TEST 72 are highlighted red because [NAME] and TEST 72 Z15 does not equal DNI
Parent Test 21 | TEST21 | Test Company 21 | Small Business Team | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Trading | Not applicable | Live record |  |  |  |  |  | 15600 | DNI
Parent Test 21 | TEST 22 | [NAME] | Small Business Team | [NAME] | [NAME] | [NAME] |  |  | TEST21 |  | TEST1 |  |  | Y | Individual |  | No | Live record | 2565 | 32077 | 0 | 0 | 0 |  | Invite | *TEST21 is not red because TEST 21 Z4 = DNI / TEST1 is highlighted red because TEST1 - Z2 does not equal "DNI"
Parent Test 31 | TEST 31 | Test Company 31 | Small Business Team | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Trading | Not applicable | Live record |  |  |  |  |  | 15600 | Invite
Praent Test 31 | TEST 32 | [NAME] | Small Business Team | [NAME] | [NAME] | [NAME] |  |  |  | TEST 31 |  | TEST 31 |  | Y | Individual |  | No | Live record | 2565 | 32077 | 0 | 0 | 0 |  | Invite | *Both are highighted red as TEST 31 Z6 do not equal DNI
Parent Test 41 | TEST 41 | Test Company 41 | Small Business Team | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Trading | Not applicable | Live record |  |  |  |  |  | 15600 | Ltd Co/LLP/PS up to £500k
Parent Test 41 | TEST 42 | [NAME] | Small Business Team | [NAME] | [NAME] | [NAME] |  |  |  |  |  | TEST 41 |  | Y | Individual |  | No | Live record | 2565 | 32077 | 0 | 0 | 0 |  | Invite | TEST 41 is highlighted red as TEST 41 (B8) Z8 does not equal DNI
Parent Test 41 | TEST 43 | [NAME] | Small Business Team | [NAME] | [NAME] |  |  |  | TEST 41 | TEST 61 |  |  |  |  |  | Trading | Not applicable | Live record |  |  |  |  |  | 15600 | DNI | TEST 61 is not highlighted red as TEST 61 (B13) Z13 does equal DNI
Parent Test 41 | TEST 44 | [NAME] | Small Business Team | [NAME] | [NAME] | [NAME] |  |  |  |  | TEST 42 |  |  | Y | Individual |  | No | Live record | 2565 | 32077 | 0 | 0 | 0 |  | Invite | TEST 42 is highlighted red as TEST 42 (B9) Z9 does not equal DNI
Parent Test 51 | TEST 51 | Test Company 51 | Small Business Team | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Trading | Not applicable | Live record |  |  |  |  |  | 15600 | Ltd Co/LLP/PS up to £250k
Parent Test 61 | TEST 61 | Test Company 61 | Small Business Team | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  | Y | Individual |  | No | Live record | 2565 | 32077 | 0 | 0 | 0 |  | DNI
Parent Test 71 | TEST 71 | Test Company 71 | Small Business Team | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Trading | Not applicable | Live record |  |  |  |  |  | 15600 | Ltd Co/LLP/PS up to £250k
Parent Test 71 | TEST 72 | [NAME] | Small Business Team | [NAME] | [NAME] | [NAME] |  |  | TEST1 | TEST 71 |  | TEST1 |  | Y | Individual |  | No | Live record | 2565 | 32077 | 0 | 0 | 0 |  | Check with Manager | All three are highlighted red as the corresponding Bcells/Zcells do not equal DNI