Complex conditional formatting
With CF you only have 3 colours (4 if you include white). From my previous
reply, you should be able to work out the CFs.
e.g change CF3:
=IF($B1$A1) ...... (say) blue
" wrote:
That just leaves white cells in the cells which are less than 10%
larger than the previous cell. What I want to achieve is, all the
cells that are greater than to be red, then the cells that are more
than 10% greater than to have something else happen, for example a
different colour font. I know this is not what I originally proposed,
but I realised that this is what I need.
|