ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   find outliers (https://www.excelbanter.com/excel-discussion-misc-queries/199491-find-outliers.html)

Steve

find outliers
 
I have many rows and columns of data. For each row I want to highlight
somehow (e.g., change background color) the entries in the columns that don't
match the value in the first column. Thanks for any help.

Gary''s Student

find outliers
 
Try conditional formatting
--
Gary''s Student - gsnu200801


"Steve" wrote:

I have many rows and columns of data. For each row I want to highlight
somehow (e.g., change background color) the entries in the columns that don't
match the value in the first column. Thanks for any help.



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com