LearnFast.Ninja

Excel 2010 conditional formatting less than

When you have list of numbers or number result and you want to highlight or color it red when the number value is less than zero, use the conditional formatting then select Highlight Cells Rules then select Less Than.

Step 1: Write some numbers make sure one of them less than 0.


Step 2: Click the Home tab > Conditional Formatting > Highlight Cells Rules > Less Than.


Step 3: Write your condition number (less then) > Click OK.


Result:


Tags

excel

conditional highlight