Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I know about the basics of boolean conditional formatting, ie. x<y,
xy etc. However, I want to be able to say that for example: If xy colour yellow, but if xy by more than 10% then colour red, so that I can see which of my results requires priority. Is there a way to do this using conditional formatting? I am using all three conditions as well, I have a traffic light system in effect, if xy colour green, if x=y colour amber, if x<y colour green. thanks. |
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 |