How to easy color cells if they have different value or same value
Results 1 to 3 of 3

Thread: How to easy color cells if they have different value or same value
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2014
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to easy color cells if they have different value or same value

    Hello

    I need to compare different projects and information on the projects -

    I need to compare, profit, cost and turnover

    For each project (I have about 50 projects) I have 3 levels of details - So I will have 3x3 cells in Excel on each project.
    For each column ie. Profit I have to compare the values of the 3 cells and see if they match or not.
    So my question is then, is there a easy function to get excel to mark the 3 cells for the three different informations (profit, turnover and cost) and compare them and if they are not identicial get it to change cell colour ?

    I perhaps have a hard time explaining my situation well, sorry for that, however I hope someone can guide me in the right direction - Thanks in advance!

  2. #2
    Board Regular Expiry's Avatar
    Join Date
    Jun 2007
    Location
    Scotland
    Posts
    865
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to easy color cells if they have different value or same value

    This is what conditional formatting is for. Look it up in the Help section.

  3. #3
    New Member
    Join Date
    Mar 2014
    Posts
    41
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to easy color cells if they have different value or same value

    Thanks !

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •