+ Reply to Thread
Results 1 to 4 of 4

Excell consitional formatting/ Cell colour problem

  1. 05-20-2009, 07:51 AM #1
    edwardtong694
    edwardtong694 is offline
    Registered User
    Join Date
    01-14-2009
    Location
    Kent,England
    MS-Off Ver
    Excel 2007
    Posts
    16

    Excell consitional formatting/ Cell colour problem

    Hi

    I have an excell problem. I would like to use conditional formating.

    However I need to compare four cells for example:

    If Cell A1 = Cell A2 and Cell A4 = Cell A5 Then

    Colour Cell A5

    Has anyone got any ideas of how to do this.

    I look forward to your reply.

    Thanks in advance

    Ed
    Last edited by edwardtong694; 05-20-2009 at 08:12 AM.
    Reply With QuoteRegister To Reply
  2. 05-20-2009, 07:55 AM #2
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Excell consitional formatting/ Cell colour problem

    Use conditional formula:

    =AND(A1=A2,A4=A5)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
    Reply With QuoteRegister To Reply
  3. 05-20-2009, 07:56 AM #3
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    Re: Excell consitional formatting/ Cell colour problem

    I did wrong...
    Never use Merged Cells in Excel
    Reply With QuoteRegister To Reply
  4. 05-20-2009, 08:13 AM #4
    edwardtong694
    edwardtong694 is offline
    Registered User
    Join Date
    01-14-2009
    Location
    Kent,England
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Excell consitional formatting/ Cell colour problem

    Thanks new it would be simple :-)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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