MS Excel
To create a formula, you first:

Select the cell you want to place the formula into
Choose the new command from the file menu
Type the equals sign (=) to tell Excel that you’re about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

Apply Conditional Formatting command on Format menu
All of above
Use =if() function to format the required numbers red
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool

ANSWER DOWNLOAD EXAMIANS APP