changing row colour depending on multiple cell values

Hey guys,

I have an excel sheet in which I would like to automatically change the row colour depending on the value of several cells.
The cols are I,J and K.
The value is either \n or date+time.

So what I tried to do was:
if the length value of cell I > 2 and length value of J & K are < 3 colour the row red.
if the length value of cell I & J are > 2 and the length value of K < 3 colour the row yellow
if the length value of I & J & K > 2 colour the row green.

But I don't think I am smart enough to make this work,
If there is anyone that can help me out with this I would really appreciate it.

TA

To do this I would use three rules specifying "Formula is", corresonding to the three conditions you describe. This assumes the rules are for row 1. Once you set them up for one row, you can use Format Painter to apply to as many rows as desired.

=AND(LEN($I1)>2,LEN($J1)<3,LEN($K1)<3)
=AND(LEN($I1)>2,LEN($J1)>2,LEN($K1)<3)
=AND(LEN($I1)>2,LEN($J1)>2,LEN($K1)>2)

My formulas are for Conditional Formatting. A macro is not necessary.