conditional formating all cells with formular?

M

Mr. Smith

Hi.
Is it possible/easy to set a condtitional formating on all cells in a
worksheet which conatins a formula? In example I want all calculated cells
to have a yellow background colour.

Kind regards
Mr. Smith
 
G

Gord Dibben

Copy/paste this UDF to a general module in your workbook.

Function IsFormula(cell)
IsFormula = cell.HasFormula
End Function

Select all cells necessary.

Then in CF>Formula is: =IsFormula(A1)

Format to yellow and OK your way out.


Gord Dibben MS Excel MVP
 
M

MartinW

Hi Mr. Smith,

No need for conditional formatting. Just hit F5 which will bring
up the Goto dialog, Click special, Check the formulas radio
button then OK. Now every cell with a fomula will be highlighted.
Set the fill color and you are done.

HTH
Martin
 
M

Mr. Smith

Great!
Thanks all of you!
Three different approaches which I learned something from, all of them.

krgrds
Mr. Smith
 
Top