ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How Highlight/Clour Cell those have same Value (https://www.excelbanter.com/excel-discussion-misc-queries/146829-how-highlight-clour-cell-those-have-same-value.html)

Qazi Ahmad

How Highlight/Clour Cell those have same Value
 
How I highlight/clour data Cell in One Culom which have same Date or same
name or same Value.
And how I can Highlight/clour date Cell in Different Culom which have same
Date or Same Name or Same Value


Toppers

How Highlight/Clour Cell those have same Value
 
Use Conditional Formatting:

Format=Conditional Formatting:

For same values in a single column:

Select column (say A)

Formula is: =COUNTIF(A:A,A1)1 (data in column A)

Format=Patters=Select colour

OK

Comparing values in two columns:

Select column (say B)

FormulaIs: =MATCH(B1,A:A,0) (Compares column B with A)

Set pattern (colour) as above.

HTH

"Qazi Ahmad" wrote:

How I highlight/clour data Cell in One Culom which have same Date or same
name or same Value.
And how I can Highlight/clour date Cell in Different Culom which have same
Date or Same Name or Same Value


Qazi Ahmad

How Highlight/Clour Cell those have same Value
 
Thank you so much this is realy i am looking. you solved my problem.
thank you.
Ahmad

"Toppers" wrote:

Use Conditional Formatting:

Format=Conditional Formatting:

For same values in a single column:

Select column (say A)

Formula is: =COUNTIF(A:A,A1)1 (data in column A)

Format=Patters=Select colour

OK

Comparing values in two columns:

Select column (say B)

FormulaIs: =MATCH(B1,A:A,0) (Compares column B with A)

Set pattern (colour) as above.

HTH

"Qazi Ahmad" wrote:

How I highlight/clour data Cell in One Culom which have same Date or same
name or same Value.
And how I can Highlight/clour date Cell in Different Culom which have same
Date or Same Name or Same Value



All times are GMT +1. The time now is 02:23 AM.

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