red Color for same value cells
Select H1:H32
with H1 the activeCell
format=Conditional formatting
formula is: =INDIRECT(CELL("address"))=H1
make red pattern the format.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("H1:H32")) Is Nothing Then
ActiveSheet.Calculate
End If
End Sub
--
Regards,
Tom Ogilvy
"Frank Kabel" wrote in message
...
Bob
saw it - neat BTW :-)
I was just too lazy...
--
Regards
Frank Kabel
Frankfurt, Germany
Bob Phillips wrote:
Frank,
See my answer.
"Frank Kabel" wrote in message
...
Hi
though this is possible (using the Selection_change event) this is
not that easy. It would be easier if you could enter the value in a
separate cell and use conditional format for this
--
Regards
Frank Kabel
Frankfurt, Germany
Aristotele64 wrote:
Hi from italy,
sorry if question was already posted but i dont'find anithing on
goole :
I have a column H1:H:32, example :
h1 Alfa
h2 Beta
h3 Omega
h4 Beta
h5 Omega
h6 Alfa
h7 P
h8 Alfa
h9 P
h10 ecc
when I click on cell taht contain "Alfa" , i want all "alfa" cell
become red if i click on cell that contain "Beta" , all "Beta"
cell
become red
TIA
|