Here is a very easy method to resolve this issue rather than using the VBA
code.
http://funwithexcel.blogspot.com/2009/04/identify-cells-with-formulas-in-excel.html
Hope this helps.
On 4/13/09, Dave Bonallack wrote:
>
> Hi,
> A quick way to reveal which cells have formulas:
> Ctrl+`
> That's Ctr
Hi Shay,
Thanks for that. Always learning.
Regards - Dave.
Date: Tue, 14 Apr 2009 10:30:53 +0530
Subject: $$Excel-Macros$$ Re: color code excel cell if a cell has a formula
From: shahinarafi...@gmail.com
To: excel-macros@googlegroups.com
Dave, You can also select cont+G, click on
HI !!
Well click on F5 - special - go to special - Formula - Click ok - And than
chose your colour.
Hope this may suffice
On Mon, Apr 13, 2009 at 11:45 PM, Ned wrote:
>
> could anyone tell me how to color code an excel cell if a cell has a
> formula. I have a long worksheet with lot of
ub
Regards
Hari Kumar
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dave Bonallack
Sent: Monday, April 13, 2009 9:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: color code excel cell if a cell has a formula
Hi,
A
Dave, You can also select cont+G, click on special tab and again click on
formula's tab, all cells whic contain formula's will get highlighted, you
can now select the fill color option and colour the cells with your
favourite colour.
Regards,
Shay
On Tue, Apr 14, 2009 at 10:24 AM, Dave Bonallack
Hi,
A quick way to reveal which cells have formulas:
Ctrl+`
That's Ctrl plus the key above the Tab key.
Regards - Dave.
> Date: Mon, 13 Apr 2009 11:15:32 -0700
> Subject: $$Excel-Macros$$ color code excel cell if a cell has a formula
> From: ned...@yahoo.com
> To: excel-macros@googlegroups.c
