ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to detect negative value cells from large size of data (https://www.excelbanter.com/excel-worksheet-functions/451565-how-detect-negative-value-cells-large-size-data.html)

[email protected] July 15th 16 08:14 PM

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

Claus Busch July 15th 16 09:22 PM

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

Mazzaropi July 15th 16 09:44 PM

Quote:

Originally Posted by (Post 1624006)
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

abhisharma2852, Good afternoon.

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.


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com