1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formating

Discussion in 'Ask an Excel Question' started by sureshmandadpu, Apr 16, 2018.

  1. sureshmandadpu

    sureshmandadpu Member

    Messages:
    36
    I want to format a range of cells based on the value of cell A1. Say, if A1=1, then A1=A4 should be yellow coloured. If A1=2, then A1=A4 should be green coloured. There are no values in A2 to A4 cells. I am unable to get this in excel. Please help.
  2. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    726
    Is it this you need?

    Attached Files:

  3. sureshmandadpu

    sureshmandadpu Member

    Messages:
    36
    No Sir.

    I attached excel file.

    Attached Files:

  4. Mr.Lobão

    Mr.Lobão New Member

    Messages:
    6
    sureshmandadpu, Good morning.

    Maybe this can help you.

    Selelct A1:A4

    Rule 1
    FORMULA -->=$A$1=1
    FILL COLOR --> RED --> OK

    Rule 2
    FORMULA -->=$A$1=2
    FILL COLOR --> YELLOW --> OK

    Please, tell us if it worked for you.

    I hope it helps.

    Attached Files:

    sureshmandadpu likes this.
  5. GraH - Guido

    GraH - Guido Well-Known Member

    Messages:
    726
    Hi, you just need to update the applied to range.
    upload_2018-4-17_16-28-36.png

    Attached Files:

    sureshmandadpu likes this.
  6. Peter Bartholomew

    Peter Bartholomew Active Member

    Messages:
    226
    Same file, same conditional formula. Just the application range changed in the Rules Manager.

    Attached Files:

    sureshmandadpu likes this.
  7. sureshmandadpu

    sureshmandadpu Member

    Messages:
    36
    Thank you Sir. I got it.
  8. sureshmandadpu

    sureshmandadpu Member

    Messages:
    36
    Thank you.
  9. sureshmandadpu

    sureshmandadpu Member

    Messages:
    36
    Thank you..
  10. Mr.Lobão

    Mr.Lobão New Member

    Messages:
    6
    sureshmandadpu, Good morning.

    Glad to have helped you.

    Thanks for the feedback.

    Have a nice day!

Share This Page