Hi, from what I understand I think this is possible; assuming that you
want the range to refer to the same row in the other sheets you could
use a simple logical IF formula, along the lines of:

=IF(OR('10feb-24 mar'!A5<'03 feb'!A5,'31 mar-19th May'!A5<'03
feb'!A5,'10feb-24 mar'!A5<'31 mar-19th May'!A5),FALSE,TRUE)

Just insert it adjacent to the range and double click the fill handle.

tweacle wrote:
I have a workbook which has 3 worksheets named 03 feb, 10feb-24 mar and
31 mar-19th May. All worksheets have data in columns A-K and have 220
entries. What im trying to do is to be able to match up data but where
its different in column A I need it highlighted.
I.E I have in cell A5 on 03 feb and 10 feb-24 mar the number 4 but in
cell A5 on 31 mar-19 may its different and has the number 9. What I
want to do is where its different I want it highlighted.

Can I do this. Thanks




--
tweacle