Select the range of numbers then
Format|Conditional Format
Cell value is - select greater than - Input a greater than number on the right
pick a colour
Click OK.
select your range | go to Format | Conditional Formatting | select 'Cell
Value Is' | in the next drop down select 'Less Than' | in the third box,
enter the value or a cell address.
Click Add to add more conditions.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.