Croaky2206
New Member
- Joined
- Jan 6, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I am looking to use conditional formatting to differentiate visually between cells which contain ANY formula and cells where a value has been keyed. So, if a cell contains a formula (e.g. '=A2+B2' or '=vlookup(...)'), I want it to change to bold blue font and where it is a keyed value (e.g. '12345' or '-1555') to just stay normal black font.
I use large spreadsheets so would rather have a generic solution for this which works wherever there is a formula, rather than having to add the conditional formatting based on a different formula per column (I can see that the latter is possible from previous threads).
My instinct was to use conditional formatting 'contains' '=' to identify cells with a formula in them, but this has not worked.
Any suggestions would be appreciated. Thanks.
I use large spreadsheets so would rather have a generic solution for this which works wherever there is a formula, rather than having to add the conditional formatting based on a different formula per column (I can see that the latter is possible from previous threads).
My instinct was to use conditional formatting 'contains' '=' to identify cells with a formula in them, but this has not worked.
Any suggestions would be appreciated. Thanks.