hwassinger
asked on
Condions in Excel
I have a spreadsheet that I need to do some review on on an ongoing basis. Is there any way to do complex conditional formatting ...
if k1 = k2 and timediff of (c1 & h1) - (c2&h2) <=60 and g1 = 47 and g2 = 2 then z2=TRUE
NEXT LINE
if k2 = k3 and timediff of (c2 & h2) - (c3&h3) <=60 and g2 = 47 and g3 = 2 then z3=TRUE
And so on through the spreadsheet
5-5-2011-5-15-18-PM.jpg
if k1 = k2 and timediff of (c1 & h1) - (c2&h2) <=60 and g1 = 47 and g2 = 2 then z2=TRUE
NEXT LINE
if k2 = k3 and timediff of (c2 & h2) - (c3&h3) <=60 and g2 = 47 and g3 = 2 then z3=TRUE
And so on through the spreadsheet
5-5-2011-5-15-18-PM.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
When I poaste the formula into a cell it only displays the formula, not the TRUE as your exanple did, what am I missing?
If it is only displaying the formula in the cell then you have probably missed the equals off the front of it (=IF(An......)
=IF(AND(K1=K2;(C1+H1)-(C2-
jppinto