Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Gwen Fields   on Oct 23 In MS Office Category.

  
Question Answered By: Hollie Hughes   on Oct 23

I need help regarding conditional formatting a cell  according to the current
time. E.g. in cell A1 I have inserted the formula =now(). In A2 I need a
conditional format so that if the time in A2 is anywhere between the time in
A1 and an hour less from the time in A1 then it should be blue. However if
the time in A2 is anywhere between the time in A1 and an hour more from the
time in A1 then it should be red.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 


Tagged: