+ Reply to Thread
Results 1 to 5 of 5

[Tip]: Conditional Formatting Highlight cells with formulas

  1. #1
    Registered User
    Join Date
    09-12-2012
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    25

    [Tip]: Conditional Formatting Highlight cells with formulas

    Hi All

    Felt the need to share. I often work on large sheets with lots of data and many formulas. To reduce calc time I often replace formulas with values but leave the formulas in the first row for refreshing purposes.
    Recently I found it useful to use conditional formatting to highlight cells with formulas.

    Select the data portion of the sheet, say A2:Z50
    Add CF rule
    Formatting based on formula
    Formula: =isformula(a2)
    Select the highlight colour required.

    Hope this is helpful for someone.
    Ron

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

    Re: [Tip]: Conditional Formatting Highlight cells with formulas

    ISFORMULA function
    Applies To: Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile

    I don't see Excel 2010 as your profile show
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,387

    Re: [Tip]: Conditional Formatting Highlight cells with formulas

    Useful to know, thanks for sharing

    On a side note - please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile says 2010, but I believe =isformula() is only available in later versions?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

  4. #4
    Registered User
    Join Date
    09-12-2012
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    25

    Re: [Tip]: Conditional Formatting Highlight cells with formulas

    will do, I hadn't noticed the version there.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,387

    Re: [Tip]: Conditional Formatting Highlight cells with formulas

    No problem, thanks for updating

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1