I put the date 10/02/02 in a cell. I used conditional formatting and put in, if cell value is less than =today()-30, then format the cell with the date as bold and blue. It works. (Today's date - 30 = 10/04). But if I replace the original cell date with 10/15 or any other future date, it still formats the cell for bold and blue, even though it is not less than today()-30???
Please help. Thanks
Please help. Thanks