Results 1 to 3 of 3

Thread: Conditional Formatting

  1. #1
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013

    Conditional Formatting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hell, Glad of some help on conditional formatting, is there a way of getting a whole row to turn red, when one of the cells has A, would turn green, B would turn Amber, and C would turn red?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,819
    Articles
    0
    Excel Version
    O365
    Just add a CF formula of

    =COUNTIF(5:5,"A")

    and set the format fill colour.

    Similar formulas for B and C.

  3. #3
    Acolyte Wings's Avatar
    Join Date
    Feb 2015
    Posts
    29
    Articles
    0
    Excel Version
    2013
    Hello Bob, thanks for that, what is the 5:5 referring too? I tried that, but only the cell with A,B,C in turns he relevant colour, is there a way I can get the whole row to change colour when the one cell has the letter in?

Posting Permissions

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