View Single Post
  #2   Report Post  
Old February 29th 16, 03:42 PM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,872
Default IF statement to show Late Arrival


Am Mon, 29 Feb 2016 07:09:17 -0800 (PST) schrieb :

I have a spreadsheet where I am entering arrival times. I would like for the text to be RED and BOLD if the time is later than 8:00am.

I started with IF(B2=8:00 am) but I know that is way too simplified.

in conditional formatting

Claus B.
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional