R
Rob
Read Knowledge Base Article - Q264372 on Microsoft for
full details.
Instead of the default positive, negative and zero
sections in the format, you can specify custom criteria
that must be met for each section. The conditional
statements that you specify must be contained within
brackets. For example, the number format
[>100][GREEN]#,##0;[<=-100][YELLOW]#,##0;[CYAN]#,##0
formats all numbers greater than 100 as green, all numbers
less than or equal to -100 as yellow, and all other
numbers as cyan.
Rob
conditional formatting or is there a different way?
full details.
Instead of the default positive, negative and zero
sections in the format, you can specify custom criteria
that must be met for each section. The conditional
statements that you specify must be contained within
brackets. For example, the number format
[>100][GREEN]#,##0;[<=-100][YELLOW]#,##0;[CYAN]#,##0
formats all numbers greater than 100 as green, all numbers
less than or equal to -100 as yellow, and all other
numbers as cyan.
Rob
ground to change to a color. How do I do that with
conditional formatting or is there a different way?