Q. When all the numbers between 0 and 100 in a range should be displayed in RedColour, apply (Solved)
1. use =if() function to format the required numbers red
2. apply conditional formatting command on format menu
3. select the cells that contain number between 0 and 100 then click red colour on text colour tool
4. all of above
- b. apply conditional formatting command on format menu