+ Reply to Thread
Results 1 to 7 of 7

Conditionally Format Formula for cells containing numbers

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    Police State of DC
    MS-Off Ver
    Excel 2010
    Posts
    8

    Conditionally Format Formula for cells containing numbers

    Which formula to use for conditionally formatting cells containing 6 numbers?

    I understand the conditional format process but am breaking down at the validation equation. I have triedL

    =$A3="******"

    =$A3="??????"

    Must be a simple syntax error?

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Conditionally Format Formula for cells containing numbers

    Explain with examples what strings you're testing.... what exactly you're testing for... give examples of similar strings that both MEET and FAIL your criteria so we can see it clearly.

  3. #3
    Registered User
    Join Date
    10-12-2011
    Location
    Police State of DC
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Conditionally Format Formula for cells containing numbers

    Sure, apologies for the lack of clarity. The gist is that a spreasheet is being populated by conditionally bringing in data from a root worksheet if formulas are met.

    - In the row where the formula is met, columns A thru I will be populated with data (columns A and B being numbers and C thru I are text data).
    - In the rows where the formula is not met, columns A thru I are populated "" placeholders.

    My goal is to border the cells of only those rows in which the formula is met. Ex:

    ..................A.....................B......................C......................D
    Row1:....123456............1......................data...............data
    Row 2: .....""....................."".......................""....................""
    Row 3:...123456............1......................data...............data

    I would want the cells of Rows 1 and 3 outlined and row 2 ignored and tried using a formula to validate the first column of each row as containing 6-digits: Thus return of 6-digitis equals success and outlining, whilst return of "" (or NOT 6 digits equals fail and no outlining)
    Last edited by slipleft; 10-12-2011 at 03:35 PM.

  4. #4
    Registered User
    Join Date
    10-12-2011
    Location
    Police State of DC
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Conditionally Format Formula for cells containing numbers

    Any good idea?

  5. #5
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Conditionally Format Formula for cells containing numbers

    Since your column A seems to only hold null strings or your 6-digit codes, why not just test for <>"" ?

    =A1<>""

  6. #6
    Registered User
    Join Date
    10-12-2011
    Location
    Police State of DC
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Conditionally Format Formula for cells containing numbers

    This test is where I began, however for some reason all rows are returning a positive - even those where the unmet formula is returning a ""

    =IF('All Actions'!$G73="On-Going",'All Actions'!A73,IF('All Actions'!$G73="Pending",'All Actions'!A73,IF('All Actions'!$G73="Initiated",'All Actions'!A73,IF('All Actions'!$G73="",'All Actions'!A73,""))))

  7. #7
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Conditionally Format Formula for cells containing numbers

    It's unclear from the formula given above what might be wrong. Can we look at the workbook together?

    In your sample workbook, make sure to point out cells where the formula IS doing what you want, and point out where it is NOT, explain there what it is supposed to show instead.

    Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.

+ 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.06495 seconds
  • Memory Usage 8,986KB
  • Queries Executed 14 (?)
More Information
Template Usage (31):
  • (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
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (7)postbit_legacy
  • (7)postbit_onlinestatus
  • (7)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 (39):
  • ./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
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (46):
  • 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
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_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