Conditional Formatting Help

[Guest]

I want for a cell to change color if one cell E15 has an R in it and if cell
G15 is more than 8.5 hours. Any help would be appreciated.

 

[JE McGimpsey]

One way:

CF1: =AND(COUNTIF(E15,"*R*"),G15>TIME(8,30,0))
Format1: <patterns>/<desired color>

 

[Dave Peterson]

maybe
=and(e15="r",g15>8.5)
or
=and(e15="r",g15>time(0,8,30))

It depends on how you enter that 8.5 hours -- is it a real time or just a
regular old number?

 

[Guest]

One more question what is the G15 is a subtraction of time however it is just
a gerneral text format?

 

[Guest]

Thanks!

 

[JE McGimpsey]

Try:

=AND(COUNTIF(E15,"*R*"),TIMEVALUE(G15)>TIME(8,30,0))