Conditional Formating with Multiple Conditions

Hi,

I need some help with excel 2007 conditional formating. I have a sheet with payment due dates and a drop down box with a Yes and No option. I want the row to change colour to red, If the due date has passed and the drop is equal to No.

 

One thought on “Conditional Formating with Multiple Conditions

  1. Kat

    Hi there

    Try entering the following formula as your conditional format.

    =AND($B2<TODAY(),$D2="no")

    I have assumed column B is the column containing due date and column D contains the yes or no option. Change your formula to accomodate your parameters.

    To get the format to work highlight your first row, go to conditional formatting and enter as a formula. Enter your formula as above. Then click OK. Then back on your worksheet, copy the row now containing your conditional format. Then select all other rows and paste special formats.

    Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *