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

Highlight Entire Row using Conditional Formatting with two conditions

Can anyone help me create a conditional formatting based on two different conditions?
I have a spreadsheet Where I have one column for Status and one for the date of reply.
I have made some conditional formatting's that colors the row red if Status is 2, and green if status is 1 or 4.

What I'm looking for is a way to make the row orange if the Status is 2 and there is a date in the column for Reply.
Please see attached example.
 

Attachments

  • Example file.xlsx
    19.1 KB · Views: 3
For Orange use
=AND($D2>0, $B2=2)
And make sure it is above the rule for red.
Also you can use one rule for green & one for red, rather than two each like
=OR($B2=1,$B2=4)
=OR($B2=2,$B2=3)
 
Back
Top