+ Reply to Thread
Results 1 to 2 of 2

Mark or highlight certain cells

  1. #1
    Registered User
    Join Date
    06-15-2013
    Location
    Israel
    MS-Off Ver
    Excel 2016
    Posts
    38

    Mark or highlight certain cells

    Hi,
    In Excel 2010 I press F5 key and then select Go To , then Special and then I select Formula. When I press the OK button all cells with formulas are shown in blue color.
    How can I keep these cells highlighted ?
    I need to do this so that when I return to the file latter I would easily find these cells.
    Can this be done to all my sheets in the work book taking into consideration that the sheets are protected.

    Will the same process work in Excel 2013 and latter version?

    Khalil Handal

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Mark or highlight certain cells

    Once you goto special - formula and the cells are highlighted go to the home tab and choose fill (and a color)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. change mark (or highlight) color
    By tsotzo in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-17-2017, 08:44 AM
  2. Replies: 2
    Last Post: 03-21-2011, 05:35 AM
  3. Highlight/ Mark similiar cells
    By 00Able in forum Excel General
    Replies: 2
    Last Post: 01-25-2011, 08:21 PM
  4. Replies: 1
    Last Post: 04-30-2009, 07:54 AM
  5. Compare two sheets and highlight/mark differences
    By richarddd in forum Excel General
    Replies: 4
    Last Post: 04-03-2009, 09:54 AM
  6. Find, highlight, mark, cut and paste macro
    By Craig Freeman in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-08-2005, 02:05 PM
  7. Replies: 5
    Last Post: 05-27-2005, 02:05 PM

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