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

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

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.