Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a cell containg a % result.
I need to know if the result fits a certain criteria as i need to format cell. The criteria is: <-20.1% = Red Between -20% & -10.1% = Amber Between -10% & 10% = Green Between 10.1% & 20% = Amber 20.1% =Red-- Can you telll me what function / formulas /conditional formating i need to use to achieve this, into my 2nd day trying to sort it out, Using excel 2007 Thanks nigeo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |