I have a column of data in an excel spreadsheet that uses the "workday"
function to create a cell value that shows a date. when you manually input a
date in one of the cells, all of the cells below auto adjust to the new dates
based on the "workday" formula. what I want to do is when a date is manually
input into one of the cells that has the workday formula in it, I want the
cell to change color if the new date is before or after the date that was
originally in this cell with the formula. when I try to input the conditional
format, I am getting an error message that I cannot refer to other worksheets
or workbooks, but all of the information is only on 1 worksheet and the
formula in the conditional format refers to that same worksheet.
please help as my Brain has frozen.
thanks.
Phil.