I want to know how to get the conditional formatting to highlight a cell if it is equal to 1 year but less than 5 years, which i have managed to work out but when I want it to do it again for between 5 and 10, 10 and 15 and so on it stops working.
Can someone help me with this?
Bookmarks