Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 15th 16, 08:14 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2016
Posts: 1
Default 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

  #2   Report Post  
Old July 15th 16, 09:22 PM posted to microsoft.public.excel.worksheet.functions
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
  #3   Report Post  
Old July 15th 16, 09:44 PM
Senior Member
 
First recorded activity by ExcelBanter: Jul 2010
Location: Belo Horizonte, Brazil
Posts: 170
Default

Quote:
Originally Posted by View Post
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.
__________________
I hope it can help you.

Best regards,
Marcilio Lob„o
---------------------------
Belo Horizonte, Brazil


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How To Detect A Negative Number In A Cell Minitman Excel Worksheet Functions 7 March 13th 08 04:12 PM
automatically numbering cells for large data from other sheets chichi0918 Excel Programming 2 June 15th 07 06:59 PM
Auto-detect range size shelfish Excel Programming 4 May 19th 06 10:21 PM
NPV Calc appears incorrect with a large # of negative cash flows MikeW Excel Worksheet Functions 1 September 1st 05 03:31 PM
Ploting data with a large range including negative numbers Hoochi Coochi Man Charts and Charting in Excel 1 April 28th 05 03:18 PM


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017