mcomp72
Active Member
- Joined
- Aug 14, 2016
- Messages
- 275
- Office Version
- 365
- 2019
- 2016
- 2011
- Platform
- Windows
- MacOS
I am interested in having the font color in a particular cell change color if the user has selected any cell on that same row. (For example, if they select a cell anywhere on row 15, the font color in cell A15 would change to red. Otherwise, it would be black.) I was able to figure out how to do this using the Workbook_SelectionChange sub. However, I need to do it without using VBA code, because whenever the sub runs, it clears the clipboard and thus my users cannot do a Copy & Paste on the sheet. I have been trying to figure out how to make this work using Conditional Formatting, but so far haven't had any luck. I haven't been able to find any existing posts about this, so I'm not sure if it is even possible to do this using Conditional Formatting. Anyone know if it is, and if so, any idea how I would do it?