It's not clear how to help because you don't tell us what is value is in each
of the cells in your formula. The formula's syntax is correct, so absent any
information about the values being tested, we can't help.

Give us more detail about what values work, what values don't work, etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"hellsbells" wrote:

I am writing a formula which will highlight cells with regard to specific
dates that have been put on the spreadsheet, however I can get it to work for
most of it but if the date is only a part way though the month it will not be
highlighted. I need it to be included - do you have any ideas how to get it
to work. The formula i am using is =IF(AND(Q$8=$F16,Q$8<=$G16),1,"").

Thanks for your help