Combining 2 working functions - no workie :(

[petermichael]

I have a simple line to color a row orange if the due date column (L) shows a date within 30 days of today.
=INDIRECT("L"&ROW())<=TODAY()+30

Since some of the values in column L are blank, I had add something to eliminate such rows
=INDIRECT("L"&ROW())<>""

Both of these work perfectly by themselves, but when I put it together, I'm doing something wrong - here is what I tried

=AND(INDIRECT("L"&ROW())<>"",=INDIRECT("L"&ROW())<=TODAY()+30)
or
=AND(INDIRECT("L"&ROW())<>"",(INDIRECT("L"&ROW())<=(TODAY()+30)))

no dice. there are various places where both conditions are true, yet, no rows get colored.

[Pepe Le Mokko]

Is there a special reason why you need the INDIRECT function? After selecting the range and supposing it starts in row 2 just use =$L2<=today()+30

Please Login or Register  to view this content.

should do