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

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

On Sat, 17 Feb 2007 22:43:48 +0100, "Mr. Smith" <(E-Mail Removed)> wrote:

>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
>

Here's one way:

http://j-walk.com/ss/excel/usertips/tip045.htm

Biff

"Mr. Smith" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>

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

Too simple<g>

Gord

On Sun, 18 Feb 2007 08:12:30 +1000, "MartinW" <(E-Mail Removed)> wrote:

>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
>

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

krgrds
Mr. Smith


"Mr. Smith" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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
>