Excel 2010 or later
Select cell A8
home tab>conditional formatting>manage rules>new rule>use a formula to determine which cells to format.
select "new rule"
type in box =A8=A7
click format >click fill tab> choose BLUE>Ok
look at preview click Ok
click in "applies to" box ....delete contents, then
select range A8:N798 >OK
All the Blue cells light up
-----------------------------------------------
select cell A8
home tab>conditional formatting>manage rules
original box comes up you can see the blue formatting you already did
new rule>use a formula to determine which cells to format
type in box =A8>A7
click format >click fill tab> choose YELLOW>Ok
look at preview click Ok
click in "applies to" box delete contents, then
select range A8:N798 >OK
All the YELLOW cells light up (BLUE ONES still lit up)
-----------------------------------------------
select cell A8
home tab>conditional formatting>manage rules
original box comes up you can see the blue formatting you already did and the yellow formatting too.
>new rule>use a formula to determine which cells to format
type in box =A8<A7
click format >click fill tab> choose GREEN>Ok
look at preview click Ok
click in "applies to" box delete contents, then
select range A8:N798 >OK
Everything is lit up
FINISHED
------------------------------------
If you made a mistake, whilst the conditional formatting dialog is showing,
EITHER
click on the colour you were formatting, click "delete rule", then start again with new rule.
OR
click on the colour you were formatting, click "edit rule" and change either the formula in the box OR click Ok and change the "applies to" range. Perhaps do both.