+ Reply to Thread
Results 1 to 4 of 4

Highlighting Specific Cells

  1. #1
    mrj1701
    Guest

    Highlighting Specific Cells

    What I would like to do is be able to show visually on the screen how to
    possibly differentiate between a cell that has a number in it and a cell that
    has a formula in it. Say one cell has a number 231 in it and then another
    cell has a sum formula in it. I would like the cell with the number in it to
    be shaded red. Is there anyway to accomplish this task.
    Thanks In advance.

  2. #2
    Bob Umlas, Excel MVP
    Guest

    RE: Highlighting Specific Cells

    Select all the cells, use Format/Conditional formatting..., change "Cell
    Value Is" to "Formula Is", then enter =ISNUMBER(A1), click the Format button,
    choose the Patterns tab, click the color you'd like for numbers.
    The A1 used above is assuming the ACTIVE Cell's address is A1. If not, then
    enter the active cell's address.

    Bob Umlas
    Excel MVP


    "mrj1701" wrote:

    > What I would like to do is be able to show visually on the screen how to
    > possibly differentiate between a cell that has a number in it and a cell that
    > has a formula in it. Say one cell has a number 231 in it and then another
    > cell has a sum formula in it. I would like the cell with the number in it to
    > be shaded red. Is there anyway to accomplish this task.
    > Thanks In advance.


  3. #3
    mrj1701
    Guest

    RE: Highlighting Specific Cells

    Unfortuanatly, when i use this commad, it will highlight a cell that is a
    formula because it gives a number result. What i would like to happen would
    be to only have the cells that have a distinct number entered into them as
    being highlighted, and if a cell has a formula, it will not be highlighted.
    Thanks.

    "Bob Umlas, Excel MVP" wrote:

    > Select all the cells, use Format/Conditional formatting..., change "Cell
    > Value Is" to "Formula Is", then enter =ISNUMBER(A1), click the Format button,
    > choose the Patterns tab, click the color you'd like for numbers.
    > The A1 used above is assuming the ACTIVE Cell's address is A1. If not, then
    > enter the active cell's address.
    >
    > Bob Umlas
    > Excel MVP
    >
    >
    > "mrj1701" wrote:
    >
    > > What I would like to do is be able to show visually on the screen how to
    > > possibly differentiate between a cell that has a number in it and a cell that
    > > has a formula in it. Say one cell has a number 231 in it and then another
    > > cell has a sum formula in it. I would like the cell with the number in it to
    > > be shaded red. Is there anyway to accomplish this task.
    > > Thanks In advance.


  4. #4
    Duke Carey
    Guest

    RE: Highlighting Specific Cells

    This is slapped together - no warranty of any kind.

    Copy the code below, then right click on the tab for the sheet where you
    want to do the testing/highlighting and choose View Code

    Paste this code in

    Public Function IsFormula(rng As Range) As Boolean
    Dim str As String
    Application.Volatile
    IsFormula = False

    On Error GoTo cleanup
    str = rng.Formula

    If Left(str, 1) = "=" Then
    IsFormula = True
    Exit Function
    End If

    cleanup:

    End Function

    Back in Excel, use conditional formatting and use FORMULA IS and use
    something like

    =isformula(A1)

    "mrj1701" wrote:

    > Unfortuanatly, when i use this commad, it will highlight a cell that is a
    > formula because it gives a number result. What i would like to happen would
    > be to only have the cells that have a distinct number entered into them as
    > being highlighted, and if a cell has a formula, it will not be highlighted.
    > Thanks.
    >
    > "Bob Umlas, Excel MVP" wrote:
    >
    > > Select all the cells, use Format/Conditional formatting..., change "Cell
    > > Value Is" to "Formula Is", then enter =ISNUMBER(A1), click the Format button,
    > > choose the Patterns tab, click the color you'd like for numbers.
    > > The A1 used above is assuming the ACTIVE Cell's address is A1. If not, then
    > > enter the active cell's address.
    > >
    > > Bob Umlas
    > > Excel MVP
    > >
    > >
    > > "mrj1701" wrote:
    > >
    > > > What I would like to do is be able to show visually on the screen how to
    > > > possibly differentiate between a cell that has a number in it and a cell that
    > > > has a formula in it. Say one cell has a number 231 in it and then another
    > > > cell has a sum formula in it. I would like the cell with the number in it to
    > > > be shaded red. Is there anyway to accomplish this task.
    > > > Thanks In advance.


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.05848 seconds
  • Memory Usage 8,891KB
  • Queries Executed 16 (?)
More Information
Template Usage (30):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (4)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (4)postbit_legacy
  • (4)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (40):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php
  • ./includes/functions_prefix.php 

Hooks Called (44):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1