how to find negative figure in various columns and rows

  • Thread starter HOW TO GO TO SHEET1 FROM WHILE WORKING I
  • Start date
H

HOW TO GO TO SHEET1 FROM WHILE WORKING I

how to find negative figure in various columns and rows
 
B

bob777

Do you want to count them?

Do you want to list them?

Do you want to convert them to positives?

IF(A1<0,"neg","not neg") will label them

using conditional formatting, you could change the cell font to red

I will try to help further when you say what you are trying to do.

Bobf
 
M

Melissa

I don't know what you plan to do with the cells once you find them but if you
just want to highligh all cells containing negative figures, you can use
conditional formatting.
1. Select all your columns and/ or rows
2. Go to Format> Conditional Formatting
3. Set your conditions. In this case, use Cells Less Than 0
4. Click on Format button and select the colours you want.
 
Top