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 <davebonall...@hotmail.com> 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
