$$Excel-Macros$$ Re: color code excel cell if a cell has a formula
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 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 > > > > > > 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 data and it it hard to > > tell which data is a formula and which is just value entered by users. > > Thanks > > > > > > -- http://funwithexcel.blogspot.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: color code excel cell if a cell has a formula
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 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 wrote: 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 > > > 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 data and it it hard to > tell which data is a formula and which is just value entered by users. > Thanks > > -- Shay A Thinker tends to use reason and logic A feeler tends to use values and subjective Judgement. Be a Thinker in Life. _ Looking for a fresh way to share photos? Get the new Windows Live Messenger. http://download.live.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: color code excel cell if a cell has a formula
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 data and it it hard to > tell which data is a formula and which is just value entered by users. > Thanks > > > > -- Regards, Shelly Mehta Chartered Accountant 9323556033 --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: color code excel cell if a cell has a formula
Hi All,
This may help. Chang the code as you want.
Sub ChangeformulaColor()
If Application.IsText(ActiveCell) = True Then
MsgBox ("Text")
Else
If ActiveCell = "" Then
MsgBox ("Blank")
Else
End If
If ActiveCell.HasFormula = True Then
ActiveCell.Select
With Selection.Font
.Name = "Arial"
.FontStyle = "Regular"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 46
End With
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Else
End If
If IsDate(ActiveCell.Value) = True Then
MsgBox ("date")
Else
End If
End If
End Sub
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 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
>
>
> 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 data and it it hard to
> tell which data is a formula and which is just value entered by users.
> Thanks
>
> http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: color code excel cell if a cell has a formula
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 wrote: > 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 > > > > > > 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 data and it it hard to > > tell which data is a formula and which is just value entered by users. > > Thanks > > > > > > -- Shay A Thinker tends to use reason and logic A feeler tends to use values and subjective Judgement. Be a Thinker in Life. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$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 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 > > > 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 data and it it hard to > tell which data is a formula and which is just value entered by users. > Thanks > > > _ Need a new place to rent, share or buy? Let ninemsn property search for you. http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Edomain%2Ecom%2Eau%2F%3Fs%5Fcid%3DFDMedia%3ANineMSN%5FHotmail%5FTagline&_t=774152450&_r=Domain_tagline&_m=EXT --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
