# Multiple criteria for Conditional Formatiing with numbers and text

1. ## Multiple criteria for Conditional Formatiing with numbers and text

I have a lot of data from laboratory results. I get the results with some values like '<0.0005', 0.0001, 0.008, etc. I have a limit I need to test these values against e.g. I want to highlight the cells that have a value >0.5. When I do this, it will also highlight the cells with values of <0.0005. A fix could be changing the <0.0005 to 0 but I don't want that as it is technically wrong. I want a formula that says "if cell is >0.5, and does not contain any text (the symbol "<"), then highlight red". Any suggestions?

2. ## Re: Multiple criteria for Conditional Formatiing with numbers and text

Maybe something like.....
=AND(M8>0.5,LEFT(M8,1)<>"<")

3. ## Re: Multiple criteria for Conditional Formatiing with numbers and text

Hi! Thank you, it seems to work but not consistently. Would you mind explaining it a bit so I can understand what I'm doing wrong?

4. ## Re: Multiple criteria for Conditional Formatiing with numbers and text

Ford's formula could be read to say, "highlight red providing the value in M8 is greater than five tenths AND the left most character in M8 isn't a less than symbol".
Let us know if you have any questions.

5. ## Re: Multiple criteria for Conditional Formatiing with numbers and text

Originally Posted by JeteMc
Ford's formula could be read to say, "highlight red providing the value in M8 is greater than five tenths AND the left most character in M8 isn't a less than symbol".
Let us know if you have any questions.
Thanks for the assist

6. ## Re: Multiple criteria for Conditional Formatiing with numbers and text

@Ford, You're very welcome.

##### Users Browsing this Thread

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.06198 seconds
• Memory Usage 9,019KB
• Queries Executed 15 (?)
Template Usage (34):
• (1)bbcode_quote
• (1)footer
• (1)forumrules
• (1)gobutton
• (6)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (6)postbit_legacy
• (6)postbit_onlinestatus
• (6)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 (49):
• 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
• tag_fetchbit_complete