# Conditionally Format Formula for cells containing numbers

1. ## 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. ## 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. ## 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)

4. ## Re: Conditionally Format Formula for cells containing numbers

Any good idea?

5. ## 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. ## 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. ## 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.

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

#### 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 (?)
Template Usage (31):
• (1)footer
• (1)forumrules
• (1)gobutton
• (7)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (7)postbit_legacy
• (7)postbit_onlinestatus
• (7)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
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
• ./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_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_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• 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