![]() Repeat the same process for 11-20 and 21-30 and you’ll see that number changes as per the value of the cell. Now enter a value between 0 and 10 in cell E3 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 transparent. 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. Then select “ Format only cells that contain,” then in the first drop down select “ Cell Value” and in the second drop-down select “ between” : Note: Make sure the cell on which you want to apply conditional formatting is selected On the Home tab, in the Style subgroup, click on Conditional Formatting→ New Rule. ![]() We can achieve this with the help of Conditional Formatting.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |