Conditional Formatting Help
 

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.

Conditional Formatting Help
 

One way:

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


In article ,
mndpy wrote:

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.

Conditional Formatting Help
 

maybe
=and(e15="r",g158.5)
or
=and(e15="r",g15time(0,8,30))

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

mndpy wrote:

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.

--

Dave Peterson

Conditional Formatting Help
 

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

"JE McGimpsey" wrote:

One way:

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


In article ,
mndpy wrote:

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.

Conditional Formatting Help
 

Thanks!

"mndpy" wrote:

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.

Conditional Formatting Help
 

Try:

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

In article ,
mndpy wrote:

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

"JE McGimpsey" wrote:

One way:

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