Hi, this is my first post.
I'm glad to be a member of this forum.
Based on conditional formatting, how can I select a cell and have the background color change to yellow if date range of another cell is for example, >= to 01/04/14 and <= 30/04/14...?
doesn't work,
Perhaps I should have mentioned that cell C4 refers to formula, =TODAY()
Maybe we can avoid cell C4, and in the conditional formatting, we can directly include the TODAY formula. So if TODAY is within the month of April then cell yellow...