change formats for a cell using the "new rule option"

Occasional Visitor

I need help to finding the "new rule option" so I can format only cells with a value less then 0

1 Reply

Hi Perry,


Highlight your values then go to Home > Conditional Formatting > Highlight Cell Rules > Less Than... 



Less than 0.gif