Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to find negative figure in various columns and rows
how to find negative figure in various columns and rows
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to find negative figure in various columns and rows
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 -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504 View this thread: http://www.excelforum.com/showthread...hreadid=504791 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to find negative figure in various columns and rows
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. "HOW TO GO TO SHEET1 FROM WHILE WORKING I" wrote: how to find negative figure in various columns and rows |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find averages not including 0's for values not in contiguous rows or columns | Excel Worksheet Functions | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Find data in columns, then place in rows | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |