Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel conditional formatting

  • 19-05-2014 11:57am
    #1
    Wearb
    Moderators, Home & Garden Moderators Posts: 6,380 Mod ✭✭✭✭


    I have two excel columns (A and B) with numbers in each. I have the rows coloured alternately yellow and blue. I want to highlight (red) the cell in column B when it matches a number on the same row in column A.
    I can do some of this with a conditional format, but when I use format painter to copy the conditional formatting down column B, it removes the cell colouring that is already there. I want to keep the same cell colouring, except for the matching ones. Is there a way to do this?

    Please follow site and charter rules. "Resistance is futile"



Comments

  • #2
    eoins23456
    Registered Users, Registered Users 2 Posts: 603 ✭✭✭eoins23456


    You could do an if statement in column c saying whether or not they are matching , filter and then colour


  • #3
    Wearb
    Moderators, Home & Garden Moderators Posts: 6,380 Mod ✭✭✭✭Wearb


    =IF(B1=A1,"cell color red")

    As you will know the above gives back text; what is the syntax for cell colour?

    Please follow site and charter rules. "Resistance is futile"



  • #4
    Peemaccee
    Registered Users, Registered Users 2 Posts: 27 ✭Peemaccee


    I managed to do this with Conditional Formatting.
    (in the style section of the home tab in excel 2010).

    You need to select Highlight Cell Rules, then Equal to. Then set the condition , =$AX , (where row num has no $) since you will be coping down the column.
    Copy it over the B column.

    Then can you put the number in column B.


Advertisement