Results 1 to 3 of 3

Conditional Formatting

Threaded View

  1. 02-21-2006, 11:35 AM #1
    Gos-C
    Gos-C is offline
    Forum Contributor
    Join Date
    09-19-2004
    Location
    Canada
    Posts
    408

    Question Conditional Formatting

    Hi Everyone,

    Using the following as an example:

    Data is in C3:E7

    Column C

    1111
    1111
    1111
    1111
    1111

    Column D

    09-Jan-06
    09-Jan-06
    01-Feb-06
    01-Feb-06
    09-Jan-06

    Column E

    Blank
    Blank
    Blank
    Blank
    07-Feb-06

    I highlighted cells H3:S1002 and entered =AND(C3<>"",ISNUMBER(MATCH(C3&D3&E3,$C1:C2&$D$1:D2&$E1:E2,0))) for Conditional Formatting but only the cell in Column H (instead of all the cells in Columns H to S) is formatted where C, D and E match. Is my formual incorrect? If so, can someone give me the correct formula.

    Thanks,
    Gos-C
    Last edited by Gos-C; 02-21-2006 at 12:06 PM.
    Using Excel 2010 & Windows 10
    "It is better to be prepared for an opportunity and not have one than to have an opportunity and not be prepared."
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1