Hello all,
I'm learning how to do custom formats on cells and it's seems like a nice alternative to having conditional formats all over the place.
I have a couple questions about the scalability of it.
If I put
[>2][red]">2";0.00
I will get a red >2 if the number is greater than 2...otherwise it's 2 decimals.
I've played around with it and other colors work and i can put more conditions (ie if a number is greater than 2 it's red but if it is less than one it's green)
Is there any way to combine conditions? Like "less than 2 AND greater than 1"???
What about making this bold or in italics?
Is there any other functionality that in this kind of formatting?
It's turning out to be quite useful as I can still refer to the value of the cell even though it states ">2" and this saves me from having to create redundant columns to summarize what is happening.
I'm learning how to do custom formats on cells and it's seems like a nice alternative to having conditional formats all over the place.
I have a couple questions about the scalability of it.
If I put
[>2][red]">2";0.00
I will get a red >2 if the number is greater than 2...otherwise it's 2 decimals.
I've played around with it and other colors work and i can put more conditions (ie if a number is greater than 2 it's red but if it is less than one it's green)
Is there any way to combine conditions? Like "less than 2 AND greater than 1"???
What about making this bold or in italics?
Is there any other functionality that in this kind of formatting?
It's turning out to be quite useful as I can still refer to the value of the cell even though it states ">2" and this saves me from having to create redundant columns to summarize what is happening.