View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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.