• 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...

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

Conditional Formating

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.
 
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.
 

Attachments

  • 17-04-2018_Conditional Formating query.xlsx
    8.2 KB · Views: 1
Back
Top