Thread: How to detect negative value cells from large size of data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
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
Reply With QuoteReply With Quote