hi,
I am finding difficulty in putting the right code in the bar, it was that;
if there is a date ( 30April2008) and the formula is applied in the very
next box of it. that if there are less than 30 days left in the date
specified box then it become red or the wording will become red.

i am not aware of what to do with the color but i was just trying to write
the basic formula first but wasn't successful
=if(a1<=date(0,0,30), red, " ")
but it didn't work out for me