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
@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 quick way to reveal which cells have formulas:
Ctrl+`
That's Ctrl plus
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 ned...@yahoo.com wrote:
could anyone tell me how to color code an excel cell if a cell has a
formula. I have a long
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
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 davebonall...@hotmail.com wrote:
Hi,
A quick way to reveal which cells have
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.com