Creative conditional formatting

[cjbrown815]

I have a column that calculates the difference between a date and todays date and colors the cell red if it is passed due. I'm wondering if I can use a happy face, sad face and angry face instead or as well. thanks

Formula
=J4-TODAY() & " " &"DAYS"

Then in the conditional formula I am changing the cell to red if it contains a "-" minus sign. Instead of turning it red I'd like to use the sad face visual or the angry face depnding on just how passed due it is.

thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[Gavona]

thread68-1542827 should do the trick.

Gavin

 

[SkipVought]

Btw don't test for a "-" minus sign, test J4-Today()<0

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}