Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Relative to adjacent cells
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Relative to adjacent cells
hi
post what CF you have tried so that we might understand why excel is saying "you can't do that." regards FSt1 "Max" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Relative to adjacent cells
If the active cell when you select CF is B2, use the condition: Cell Value
Is/ greater than/ =A1 (or =A2, or whatever cell you wish to use with which to compare B2), then select your format for greater. Then Add, and do the equivalent for less than. What are you trying to do when it tells you that you can't do it? What, exactly, is the error message? -- David Biddulph Max wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting on ADJACENT Cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Non-Adjacent Columns | Excel Worksheet Functions | |||
Conditional Formatting based on adjacent cell value | Excel Discussion (Misc queries) | |||
Conditional Formatting for adjacent cells | Excel Discussion (Misc queries) | |||
conditional formatting adjacent cells | Excel Worksheet Functions |