Formatting (XP)

Topic

New Reply

I have to do some conditional formatting
But I have more then 3 conditions. When the value in the cell is either T-9 or 10 the cell should go green, when the cell content is either C6, 7 or 8 it goes orange and when its S1, 3,4 or 5 it should go red.

I have no problems making it conditional using just the T C or S, but I don’t know how to do it when there are 9 conditions.

Can someone please help
Thanks so much
Cheers

Reply | Quote

Replies

Check out more then 3 conditions with conditional formatting (XP/2003)

Steve
PS: do you have 9 conditions and 3 formats or 9 different formats? it is the number of formats (you can have only 4: an explicit and 3 conditional) that is the issue, not the conditions…

Reply | Quote

I have 9 conditions and 3 formats
Perhaps I have to have very small columns, put the T in one column and the 9 or 10 in another and figure out a way to have both cells look as one…
Amazing isn’t it, excel is so complex and then it doesn’t do what I want
Thanks for sending that link anyway

Reply | Quote

if the conditions are what you describe (and I understand it correctly)

You can have the conditions (assuming the cell selected is A1
Formula is
=or(A1=”T-9″, A1=”T-10″)

Formula is
=or(A1=”C6″, A1=”C7″, A1=”C8″)

Formula is
=or(A1=”S1″, A1=”S3″, A1=”S4″, A1=”S5″)

And set the formats appropriately

[If there is more than 1 cell to format, then select all of them and use the active cell as the reference in formulas, it will be set to all in a relative manner]

Steve

Reply | Quote

The limit on conditional format isn’t really three conditions – it is three formats. You can combine more than one logical test with a logical AND or an OR to form the condition that will trigger a particular format. I wasn’t sure whether you meant that the value of the cell would be the literal (string) value of -say- “S1” or it would be equal to the value in cell S1 (etc). I assumed the former, but the approach would be the same. The test for one of the conditional formats will be something like (for the cell B4 – obviously that part changes as required):

"Formula Is"
=OR(B4="S1",B4="S2",B4="S3",B4="S4")

the condition would evaluate as “TRUE” if the cell takes on any of the values “S1” through “S4” and in this case would apply a red pattern: other conditions would apply the appropriate green or orange colour.

If you wanted to test for equality with the values in Cell S1 (etc) you would change the condition so it wasn’t testing for a match with the string value “S1” (etc), but just whether B4=S1 (etc).

Reply | Quote

WOW… that worked like a treat..
Thanks heaps

Reply | Quote