+ Reply to Thread
Results 1 to 5 of 5

Conditional Formatting Formulas

  1. #1
    Registered User
    Join Date
    09-22-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2003
    Posts
    20

    Exclamation Conditional Formatting Formulas

    Hi All,

    Aim/ Object — We have two columns - B and C, the column 'B' tells about the action name (what action is happening or has done), and the column 'C' tells about the time of the action.

    I want to put a condition formatting in the column 'C', as follows:
    If column 'B' has 'Welcome' as text/ value, then in the column 'C' (next cell), the condition formatting color should be in 'Green'.
    If column 'B' has 'Start ' as text/ value, then in the column 'C' (next cell), the condition formatting color should be in 'Blue'.
    If column 'B' has 'Goodbye' as text/ value, then in the column 'C' (next cell), the condition formatting color should be in 'Brown'.

    Note — Color formatting for the cell value/ text - 'Time Take Duration' :
    If the 'Time Take Duration' is less than 1:15:00, then there should be 'Yellow' color in the next cell (column C).
    If the 'Time Take Duration' is greater than 1:15:00, then there should be 'Red' color in the next cell (column C).

    All this need in the Excel 2003.

    Please help me out!

    Thanks in advance!
    Attached Files Attached Files
    Last edited by SunOffice024; 09-26-2010 at 05:33 PM. Reason: Please provide me the result in the Excel 2003.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Conditional Formatting Formulas

    Hi,

    See the attached.

    Incidentally it would pay to update your details. I was about to respond that with 2003 you are limited to 3 conditional formats. Then I noticed your file was a 2007/2010 file which handle many more CFs.

    HTH
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-22-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Conditional Formatting Formulas

    Thanks a lot! It works fine in 2007, but doesn't work in excel 2003.

    I need to do this sort of formatting in 2003.

    Sorry for inconvenience.

    Plz check the attached now in excel 2003.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Conditional Formatting Formulas

    Hi,

    As I said, with 2003 you are limited to 3 conditional formats. If any of the cells can have any of the 5 conditions you can't do it with CFs, and you'd need to resort to a VBA user defined function.

    If however you are prepared to have two definitions of conditional formats, one with 3 formats for the Welcome Start Goodbye cells and the other with 2 formats for the Time cells, then just use the examples in my last file e.g. using the Formula Is option, enter the 3 formats with the following,

    Please Login or Register  to view this content.
    and the two formats using the Cell value option with the greater than or equal to choice, and less than choice
    Please Login or Register  to view this content.
    HTH

  5. #5
    Registered User
    Join Date
    09-22-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Conditional Formatting Formulas

    If however you are prepared to have two definitions of conditional formats, one with 3 formats for the Welcome Start Goodbye cells and the other with 2 formats for the Time cells, then just use the examples in my last file e.g. using the Formula Is option, enter the 3 formats with the following,
    Thanks a world dear!

    Got it!

    I just selected all the required cells in the column 'C', then Format Menu > Conditional Formatting

    Please Login or Register  to view this content.
    Thus if the cell of column 'B' is blank then the relative cell of column 'C' will be blank with 'no formatting'.
    Please correct me if I am wrong at any point.
    Last edited by SunOffice024; 09-27-2010 at 07:37 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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 1.47486 seconds
  • Memory Usage 8,970KB
  • Queries Executed 15 (?)
More Information
Template Usage (34):
  • (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
  • (3)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (5)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (4)postbit_attachment
  • (5)postbit_legacy
  • (5)postbit_onlinestatus
  • (5)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
  • ./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 (48):
  • 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
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1