Conditional Formating expired dates

Good Afternoon,

Your assistance is once again greatly needed. and i will try to be specific.

I have Four Columns with Hundreds of Rows that contain data.

• Column A = Name of Document
• Column B = Issued Date
• Column C = Expired Date
• Column D = Verified

I would like the "Verified" Cell to Turn red when the "Expired Date" cell has Expired. Verification happens on a monthly basis (I am not sure if that is important)

Please help and let me know if i need to provide more data.

Many thanks in advance!
Sandra

Thanks a million!

This might be against the rules but am i able to ask one more question?

If and when the Verified column is red & i put a new date in it, can i turn it clear again?

No i believe you understood correctly.

Remember i have four columns. The verified column is always blank and is based off of the Expired column.

The verified column will always be empty but i want it to turn red if the expired column turns red. Once it turns red, and i add a date to the verified column to it, i want it to turn to clear.

does that make sense?

Thanks a million!

What i did was i made the Expiration Date the column that turned red, and it all works out for me!