Urgent help needed

[Eznieh]

i want to turn a column in excel where the time is inputted to start a time then after 1 hour has elapsed it needs to turn red.

eg input time 1500 at 1600 box will turn red !

i would very much appreciate someones help on this asap many thabks

 

[Eznieh]

come on guys please haha

 

[dave3009]

Hi, welcome to the forum

First things first, you should familarise yourself with the forum rules, subjects marked as 'Urgent' will not be treated as such.

Item 12 - http://www.mrexcel.com/forum/excel-questions/127080-guidelines-posting-updated-22-nov-2006-a.html

You can use conditional formatting, formula is: =TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW()))>A2 assuming you enter the time in A2

 

[Eznieh]

Hi sorry i have been browsing the forum for a while ! have never joined as my excel skills are very poor and i really would not have anything positive to give to other members. I basically have not got a clue