Previous Topic Next Topic

Excel if statement using time

Closed
carview Posts 1 Registration date Monday November 4, 2013 Status Member Last seen November 4, 2013 - Nov 4, 2013 at 05:09 PM
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 - Nov 5, 2013 at 02:04 AM
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

Answer 1 / 1
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Nov 5, 2013 at 02:04 AM
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
0

Similar discussions

The system time is invalid
LeonardPromise -
Anonymous User -

5 responses