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
 
This worked!!! This is going to save me hours of time each month. Thank you!!!

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 3
Time Validation 1
Validation 1
Conditional formatting with time 4
Entering Times In Excel 8
Entering Times 9
Cut & Paste in Excel without erasing cell borders? 1
IF calculation of Time 2

Back
Top