Thread
:
IF statement to show Late Arrival
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
IF statement to show Late Arrival
Hi,
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.
try:
=B25/6
or
=B2TIME(20,0,0)
in conditional formatting
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch