Previous Topic Next Topic

Excel if statement using time

Closed
carview Posts 1 Registration date Monday 4 November 2013 Status Member Last seen 4 November 2013 - 4 Nov 2013 à 17:09
Kevin@Radstock Posts 42 Registration date Thursday 31 January 2013 Status Member Last seen 26 April 2014 - 5 Nov 2013 à 02:04
Hello,

I am trying to do some conditional formatting using if statement. I have a spreadsheet that is supposed to flag targets based on a 24hr clock. If a target is 24hr or less then the indicator should flag green, if it is 24hr or greater then it should flag red. I am using the following formula in excel 2010 [=IF(cell>TIME(24, 0,0),"RED",IF(cell<=TIME(24,0,0),"GREEN"))]. Can someone please tell me what I am doing wrong as it does not appear to be working.

Frustated Carview.
Related:

1 response

Réponse 1 / 1
Kevin@Radstock Posts 42 Registration date Thursday 31 January 2013 Status Member Last seen 26 April 2014 9
5 Nov 2013 à 02:04
For the Green condition, on the home tab > Conditional formatting > New rule > Use a formula to determine which cells to format > Use the following formula: =cell<=1. Format the cell as green fill.

Repeat for the red condition. Formula: =cell>1 and format the fill as red.

Kevin

Similar discussions

Connection keeps timing out
Kimber -
Jeff -

29 responses
Excel - IF function with multiple words
Nick -
user -

14 responses