Yakuzaapn

Then, on the first box, enter 0 and in the second box, enter 10, then click on the Format button and go to Fill Tab, select the blue color, click Ok and again click Ok Now enter a value between 0 and 10 in cell and you will see that cell color changes to blue and if there is any other value or no value then cell color revert to transparentEXCEL Select data > Home tab > Style group > Click on Conditional Formatting > New Rule > Select Format only cells that contain > Select less than or equal to > > Enter number > Select color > Click OK 1 Select the range in which you want to highlight cells if the number is less than or equal to a specific numberThen in the New Formatting Rule dialog, select Format only cells that contain in the Select a Rule Type section, and if you want to change font color if cell value is negative, you can choose Cell Value from first list and choose less than from the middle list, and then type 0 into the right text box 1 Excel form