if statement needed?

[chearn]

My cell is foratted for :mm:ss , how do i format the cell for the following statement?

If the time is greater than :04:01 but less than :59:59 bold the font and highlight the cell

I am lost

 

[Greg Truby]

<ul>[*]Format | Conditional Format... .[*]Cell Value Is.[*]Between.[*]Box1: =time(0,4,2).[*]Box2: =time(0,59,58).[*]Set font and shading properties to your desire.[/list]

HTH

 

[Zack Barresse]

Hi chearn, welcome to the board!


You could use conditional formatting. I placed these values in some adjacent cells ..

Book2
	A	B	C	D	E
1			Minutes	4	59
2	:04:01	:04:01	Seconds	1	59
3	:04:02	:04:02	NumberV	0.002789352	0.041655093
4	:04:03	:04:03		:04:01	:59:59
5	:04:04	:04:04
6	:04:05	:04:05
7	:59:51	:59:51
8	:59:52	:59:52
9	:59:53	:59:53
10	:59:54	:59:54
11	:59:55	:59:55
12	:59:56	:59:56
13	:59:57	:59:57
14	:59:58	:59:58
15	:59:59	:59:59
16	:00:00	:00:00
17	:00:01	:00:01
18	:00:02	:00:02
19	:00:03	:00:03
Sheet1

Selecting A2:A19, I went to Format --> Conditional Formatting --> Formula Is ...

=(A2<>"")*((A2-INT(A2)>$D$4)*(A2-INT(A2)<=$E$4))

Hope this helps.


Note: The Conditional Formatting does NOT show up using Colo's HTML Maker that I posted with. The cells were formatted after the fact to show you which results came up.