Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc, microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
Hi,
I have a small problem. I am trying to do a trend condition where for example: I have 12 numbers in a row. 3,4,5,5,5,5,6,3,4,7,2,3 I need any one number to go RED or GREEN depending on if it is less than or greater than the preceeding number. That is the easy part. Then I need the number to turn AMBER if it is equal to the one preceeding it, again easy. The problem now is that if I have three AMBERs in succession and the fourth is also equal to the preceeding three I need them all to go RED. I can get the 4th number RED but because the first number (of the four) is either RED (less than) or GREEN (more than) it does not accept it as being equal to any of the other AMBERs. How do I get all 4 equal numbers in succession to change their colour to RED? Thank you John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |