Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Cell If | Excel Discussion (Misc queries) | |||
How do I have data bars WITHOUT the clour fading to the right? | Excel Discussion (Misc queries) | |||
Highlight Cell | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
can i colour a cell on basis of results of a formula e.g clour bl. | Excel Worksheet Functions |