I don't know if this may help or not, but. .
We had a situation where we needed to format in one of either of four
different colours depending on the number entered into the cell;
eg: 1 to 3 = yellow, 4 to 8 = blue, 9 to 15 = green, and greater than 15 =
red.
We over came this simply by formatting the column of cells to yellow.
Then used the conditional formatting to test the remaining three scenarios.
Like I said this may not be what you need. . . . .

"Udayan" wrote:

Sorry I mean 4th Conditional Formatting