View Single Post
  #2   Report Post  
Old July 15th 16, 09:22 PM posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,853
Default 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