Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a very large spreadsheet where I would like to use conditional formatting...I have the columns set up with times as follows

Arrival Time Triage Time Registration Time To ED Time DC Tim

Numerous people input the times and they are not always correct (people are DC before they arrive, etc.) There are about 3,000 lines for one months worth of data.

Is there a way I can put Conditional Formatting so that if Triage Time is Less than Arrival Time then it can highlight a cell?

Thank

Denise
 
Glad to help Denise. And thanks for the feedback

----- Denise wrote: ----

This worked!!! This is going to save me hours of time each month. Thank you!!!

Denise
 
Back
Top