Hi,
seems like the only way to do following:
change A1 cell color based on A2 color, no other (traditional conditional format approach) conditions needed
is to use VBA. Conditional format does not work here and haven't been able to come up with formula based approach. Will use the VBA as an last option, but anyone knowing any workarounds for change of cell color?
No, not possible without VBA if the cell colour of A2 has been applied manually (i.e. not via a CF rule).
Shall I move the thread for you?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi,
thanks for reply - exactly as I though, only VBA.
So, yes you can move the thread.
Done, and updated the thread title to match.
Hi,
seems like there's an simple wa by VBA with following code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.Range("D1").Interior.Color = Me.Range("B1").Interior.Color
End Sub
So, I might consider this as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks