Hey guys,
in a workbook im working with, it gets updated daily from 2 other workbooks.
I have a sheet called Data and Sheet1 which will be the two i'm trying to get help with.
Sheet1 has Column C which currently ranges from 13xxx to 13917 -- but will increase as it gets updated
Data has Column F which gets updated each day and i've got it set to show the highest number in Sheet1, Column C, currently 13917
what i want to do, is on Sheet1, to highlight any rows that have value between 13915-13917 in Column F -- so anything newer than 13914/2nd last cell to 13917/bottom cell
Thanks in advance for any help on this, if i haven't explained this well, im sorry, but it makes sense as i read it haha
NZT
in a workbook im working with, it gets updated daily from 2 other workbooks.
I have a sheet called Data and Sheet1 which will be the two i'm trying to get help with.
Sheet1 has Column C which currently ranges from 13xxx to 13917 -- but will increase as it gets updated
Data has Column F which gets updated each day and i've got it set to show the highest number in Sheet1, Column C, currently 13917
what i want to do, is on Sheet1, to highlight any rows that have value between 13915-13917 in Column F -- so anything newer than 13914/2nd last cell to 13917/bottom cell
Thanks in advance for any help on this, if i haven't explained this well, im sorry, but it makes sense as i read it haha
NZT