Conditional Formating

[Dale McCulloch]

I have a Excel list that contains:
Column A - Employee Number
Column B - Employee Name
Column C - Received (which is a date)
Column D - Target Date (which is a date)
I have to create a conditional format to determine weather the employee has missed their target date. If the have missed the target date I have to display their name in column B with a red background and white font.
thanks.

 

[VoG]

Use the Formula Is option and

=C1>D1

 

[T. Valko]

I have a Excel list that contains:
Column A - Employee Number
Column B - Employee Name
Column C - Received (which is a date)
Column D - Target Date (which is a date)
I have to create a conditional format to determine weather the employee has missed their target date. If the have missed the target date I have to display their name in column B with a red background and white font.
thanks.

How do we know if they missed the target date? Is it when the received date is greater than the target date?

 

[Dale McCulloch]

Yes if the Received date is greater than the Target Date

 

[Dale McCulloch]

Yes if the Received date is greater than the target date

 

[T. Valko]

Yes if the Received date is greater than the Target Date

OK, Peter's suggestion will work.

 

[Dale McCulloch]

Thanks, worked great!