Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complex or Conditional Countif(s) | Excel Worksheet Functions | |||
Complex cond. formatting...Pls. Help! | Excel Discussion (Misc queries) | |||
complex conditional format | Excel Discussion (Misc queries) | |||
complex?? Q about Conditional formatting | Excel Worksheet Functions | |||
Complex Conditional formulas | Excel Worksheet Functions |