Conditional formatting using nature of cell content

[Croaky2206]

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.

 

[Joe4]

Welcome to the Board!

My instinct was to use conditional formatting 'contains' '=' to identify cells with a formula in them, but this has not worked.

You should just be able to use the ISFORMULA function, which tells you if a formula exists in a cell.

See: How to use the ISFORMULA Function in Microsoft Excel

 

[Fluff]

Hi & welcome to MrExcel.
You can use a formula & use

=ISFORMULA(A1)

 

[Croaky2206]

Thanks for the quick responses - that's worked a treat

 

[Joe4]

You are welcome.
Glad we were able to help.