+ Reply to Thread
Results 1 to 1 of 1

Conditional formatting of multiple cells found in different worksheet

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    Quatre Bornes - Mauritius
    MS-Off Ver
    Excel 2010
    Posts
    10

    Conditional formatting of multiple cells found in different worksheet

    Dear Friends,

    I'm having a lot of trouble figuring out how to do the following and I would be most grateful if you could please help me out.

    I have an MS Excel 2010 workbook with worksheets named '1' to '12' and another sheet named 'Availability'.
    Sheets '1' to '12' represent each month of the year whereby users input their tasks in text format (no numeric value) on a daily basis.
    I'm looking for a way to format the corresponding cells in sheet 'Availability' whenever a user inputs something in their respective cells in sheet '1', '2', '3', etc .

    For example - John would put 'aaa' in cell b6 in sheet '1' and cell B13 background would turn red.

    I tried to use Conditional formatting but the process is too tedious.
    The ideal solution will be once any text is input in a cell, the corresponding cell in sheet 'Availability' change to red.

    Grateful if anyone could please inform me whether this can be done using VBA and if possible how it can be done.

    Attached is a sample of my workbook and contains only sheets '1' and 'Availability' .
    All other sheets are for the remaining months and are of the same display, format and size.

    Thank you beforehand for your assistance.

    Best regards,

    Shameem
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting "No cells were found"
    By minamina6 in forum Excel General
    Replies: 2
    Last Post: 05-20-2015, 10:57 AM
  2. [SOLVED] Conditional formatting multiple cells based on multiple cells
    By jhuvba in forum Excel General
    Replies: 2
    Last Post: 05-18-2015, 12:19 PM
  3. Replies: 6
    Last Post: 02-25-2015, 08:54 PM
  4. Conditional Formatting with Multiple Criteria - selecting within worksheet?
    By MiddleHughes in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2015, 11:26 AM
  5. Replies: 6
    Last Post: 05-30-2013, 02:09 AM
  6. [SOLVED] Can conditional formatting be used to evaluate a range of cells on a different worksheet?
    By TheITQuest in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-10-2013, 04:55 PM
  7. [SOLVED] Conditional Formatting based on multiple strings in multiple cells
    By lily_ruiz_06 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-27-2013, 04:23 PM

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.10004 seconds
  • Memory Usage 8,867KB
  • Queries Executed 16 (?)
More Information
Template Usage (33):
  • (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)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (1)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (1)postbit_legacy
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (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
  • ./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 (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_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_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1