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


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

Claus B.
Office 2016