View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Conditional Formatting for times

Any help on how to make hours & minutes work to show if someone is late

Let's say you want to CF col A for any arrival times greater than 7:10 am
Select col A (A1 active), apply CF for Condition 1 using "Formula Is":
=AND(ISNUMBER(A1),A1--"7:10 am")
Format to taste
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---