Unless I've misunderstood (likely)
Highlight A3 and goto conditional formatting.
Select 'Cell value' 'equal to' 'A16' and define whatever format you want A3 to appear as if it's a duplicate of A16.
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Conditional formatting in subtotalled rows"
Collapse
-
Conditional formatting in subtotalled rows
Hi guys
Need to pick your brains again if you would be so kind. I need to be able to conditionally format subtotalled rows so that duplicates are indentified - e.g. the subtotals are in rows A3, A16, A24, A36 and the duplicates would be A3 & A16. Either that or I need to add in a formula that would appear next to the subtotal row when the subtotal itself is at level 2.
Hope that makes sense (although I would be surprised on a Friday afternoon) - any help appreciated
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Why might an umbrella company fail to pay its total tax bill to HMRC? Aug 18 06:08
- Contractors, here are the late payment fixes that the Lords just turned down Aug 17 08:03
- How will HMRC's Direct Debit plan affect contractors paying VAT and PAYE? Aug 13 23:54
- HMRC's new 'reckless' tax offence: an IR35 game-changer for contractors? Aug 13 13:50
- “I’m not a Machiavellian overlord”: Adrian Sacco breaks his silence on the Contractor Loan Recalls Aug 13 06:50
- ‘Bounce back’ in IT contractor demand in July 2026, even if ‘one swallow doesn’t make a summer’ Aug 12 07:50
- Are fractional and interim CTO roles ripe for IT contractors? Aug 11 07:33
- Where is UK IT contractor demand heading before 2027? Aug 10 05:53
- Where is UK IT contractor demand heading before 2027? Aug 9 21:53
- Umbrella, PEO/GPP, or salaried EOR. Which is up 153% in 2026? Aug 6 08:43

Leave a comment: