Hi, my knowledge of excel is nowhere near where most of you are and I have a question about conditional formatting.
Lets say I have a cell with a date in it and if that date has passed I would like the cell to change to red. So I highlighted the date cells and selected conditional formatting, I filled in the dialog box so it was cell value is less than today() but no matter what date I put in there it changes to red.
I tried finding the answer myself but had no luck. Thanks
Lets say I have a cell with a date in it and if that date has passed I would like the cell to change to red. So I highlighted the date cells and selected conditional formatting, I filled in the dialog box so it was cell value is less than today() but no matter what date I put in there it changes to red.
I tried finding the answer myself but had no luck. Thanks