View Single Post
  #3   Report Post  
Old July 15th 16, 09:44 PM
Mazzaropi Mazzaropi is offline
Senior Member
First recorded activity by ExcelBanter: Jul 2010
Location: Belo Horizonte, Brazil
Posts: 170

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.
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.

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