M
Max
Hi Guys,
Here is my problem: I havea table of data, rows of figures split in to
columns according to date. What I would like to do is compare each figure
with the previous date's figure (quartely, though that should make no
difference). All conditional formatting seems to be able to do for me is
simply compare all the data and grade them subsequently and every time I try
a relative formula (though I am probably doing it wrong) it tells me I cannot
do it.
What I basically want to do is highlight, for each piece of data, whether or
not is was higher or lower than the previous quarter. Is this possible
without going through every piece of data?
Thanks in advance for your help,
Max
Here is my problem: I havea table of data, rows of figures split in to
columns according to date. What I would like to do is compare each figure
with the previous date's figure (quartely, though that should make no
difference). All conditional formatting seems to be able to do for me is
simply compare all the data and grade them subsequently and every time I try
a relative formula (though I am probably doing it wrong) it tells me I cannot
do it.
What I basically want to do is highlight, for each piece of data, whether or
not is was higher or lower than the previous quarter. Is this possible
without going through every piece of data?
Thanks in advance for your help,
Max