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

Copper Contributor

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