| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to detect negative value cells from large size of data
Can anyone suggest how to detect Cells containing negative values form large size of data approx. having 100 columns and rows because filtering the data 100 times not make sense.
Thanks Abhishek |
|
#2
|
|||
|
|||
|
Quote:
Is a Conditional Formatting an option for your case? If so, try it: Select your cells. Choose Conditional Format Menu -- Cells that have Value: Less than -- 0 -- Select Fill color you want. OK All the negative cells will be colored instantly. Please, tell us if it worked for you.
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to detect negative value cells from large size of data
Hi,
Am Fri, 15 Jul 2016 12:14:53 -0700 (PDT) schrieb : Can anyone suggest how to detect Cells containing negative values form large size of data approx. having 100 columns and rows because filtering the data 100 times not make sense. try Conditional Formatting Regards Claus B. -- Windows10 Office 2016 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To Detect A Negative Number In A Cell | Excel Worksheet Functions | |||
| automatically numbering cells for large data from other sheets | Excel Programming | |||
| Auto-detect range size | Excel Programming | |||
| NPV Calc appears incorrect with a large # of negative cash flows | Excel Worksheet Functions | |||
| Ploting data with a large range including negative numbers | Charts and Charting in Excel | |||
Hybrid Mode
