Formula in Conditional formating can't figure out 2nd part

1. Formula in Conditional formating can't figure out 2nd part

=AND(\$G1>=I\$1,G1<j\$1,\$H1>I\$1)
=+AND(NOT(I\$1<\$G1),not(I\$1>\$H1))
These are the formulas I have for my conditional formating I want to add to them to read column E to know what color to fill cell instead of choosing formating color for each section. see attached

2. Re: Formula in Conditional formating can't figure out 2nd part

i cant upload your file at the moment, only have 2003 here, but i find the easiest way to figure out formulas like that for CF is to make them up in the spread sheet 1st (instead of the time-consuming method of puting them into the CF straight away). that way, you can play with them and see if they return the TRUE and FALSE that you expect

also, try modifying your 2nd formula to...
=AND(I\$1>=\$G1,I\$1<=\$H1))
it shouldnt make any difference, just a bit more simplified

3. Re: Formula in Conditional formating can't figure out 2nd part

Hi

If I understand this correctly, you want to change the colour of your conditional formatting to match another cell in your spreadsheet (the cell in column E of that row). CF won't allow you to reference another cell for the format (the only way to do that, AFAIK, is with a macro). However:

I notice that the colour in Column E is already determined by CF, so you could extend the range that this applies to so the whole row becomes that colour when you select the name. After that, reverse the condition the bars [e.g. AND(\$G1<I\$1,G1>=j\$1,\$H1<=I\$1)] and change the format to white fill when they don't fall within the dates.

Hope this made sense and helps.

Cheers, Rob.

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.05690 seconds
• Memory Usage 8,878KB
• Queries Executed 15 (?)
Template Usage (32):
• (1)footer
• (1)forumrules
• (1)gobutton
• (3)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (1)postbit_attachment
• (3)postbit_legacy
• (3)postbit_onlinestatus
• (3)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
• ./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

Hooks Called (47):
• 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_attachment
• postbit_display_complete
• memberaction_dropdown
• tag_fetchbit_complete
• forumrules