how do i make a cell turn red if value is less than 0?

  • Thread starter Thread starter Megglesface
  • Start date Start date
M

Megglesface

i have a list of numbers on my worksheets, inclusing some zeros. i would a
formula that means whenenver a cell just has 0 in it it will show as red.

Is this possible?

Thanks
 
Use conditional format ,,,, where cell value equals "0" ,,, format to RED
 
1) Select all the cells that have numbers.
2) Format->ConditionalFormatting
3) Under Condition1
Cell Value is ... Equal To ... 0

Click the format button & give any format that you want. This will change
all 0's to that color/format.

HTH,
 
You must log in or register to reply here.

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.

Ask a Question

Similar Threads

Conditional formatting Problem 3
Cell Formatting 5
***Conditional Formatting Multiple Cells*** 1
blank if sum is less than 0 5
Make cell value zero if cell formula returns value less than zero? 3
Make ZERO red and bold 6
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Make a cell font red if number is greater than 200 4

Back
Top