Hi
I have the following formula which I am using in the conditional formating option with highlight red in formatting.
=AND(G2-TODAY()>=0,G2-TODAY()<=2)
If I am doing this right the fiormula should highlight any dates in column G2 that are going to expire within 2 days of the current days date or if they have already expired.
Obviously there is something wrong as I cannot get ths to work, cells do not highlight when the condiotion is set.
Help appreciated.
Gary
I have the following formula which I am using in the conditional formating option with highlight red in formatting.
=AND(G2-TODAY()>=0,G2-TODAY()<=2)
If I am doing this right the fiormula should highlight any dates in column G2 that are going to expire within 2 days of the current days date or if they have already expired.
Obviously there is something wrong as I cannot get ths to work, cells do not highlight when the condiotion is set.
Help appreciated.
Gary
