Hi
I need help with the following please:
1 have 2 columns, A (Date first Recorded) and B (Date last Recorded).
32 rows, where data can be entered.
I would like to set up conditional formatting in the cells in column B.
I would like flag icons if the difference in days between column A & B are a certain amount, e.g. less than 30 = yellow, more than 60 = red.
I've tried various formulas, incld DatedIF, etc. When i apply this to the formatting rules 'creator' nothing happens? no flag appears!
I've made sure that the formula works in a different cell.
Will appreciate any help.
Tx!
Bookmarks