Automatic text formatting in Excel 2003
I'm new to the forum, don't know if I can ask a question on Excel here? In general, I have a large list of surnames and numbers opposite each one, I need to highlight the numbers up to 20 in one color, 20-35 in another color, and above 35 in the third. And also change the font of the numbers at these intervals. How do I do this?
Please help me.
P.S. Excel 2003
1 answers
The cell format can be changed using conditional formatting (UV)
In Excel-2003, no more than three conditions can be set in the UV.
Formulas for the first and third ranges (we accept the placement of numbers in column B):
=B1<20
=B1>35
If the first condition is set for the middle range, then you will have to specify the boundaries of the range:
=ЕСЛИ(B1>=20;B1<=35)
=ЕСЛИ(И(B1>=20;B1<=35);1)
=И(B1>=20;B1<=35)
The first formula of these three is better - if the first condition is not met, the second one is not checked.
But if the conditions are set sequentially, the lower bound can not be checked (it is checked in the first condition):
=B1<=35
Since all numeric values fall under the conditions, you can limit yourself to only two conditions-initially fill the range with one color. In UV, you can change not only the cell color, but also the color, appearance, font size, cell border, and other formats.