View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] neillstoddart@hotmail.com is offline
external usenet poster
 
Posts: 3
Default Conditional Formatting in Excel 2007

I have a column of cells which are formatted as either General or
hh:mm.
What I want is - if A1 = Off & A2 is less than 06:00 then A1 is
highlighted in red text.
Haven't found anything that works yet.
Can anyone help?
Thanks