I am attempting to use conditional formatting on a column in a data set. I want to highlight any cell that is less than six months old. I can figure this out normally but it is someone elses data set I am attempting to modify without changing the data and the data in the column is stored as
Last Sale: 07-18-2003 Sale Amount: $0.00
I can write formulas to pull the date out of the cell and I can write formulas to compare the date with today()-180 but when I attempt to do it as a conditional formula nothing happens. Anyone have a clue what I need to do to get the conditional formatting working.
