| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Font Color for Dupes on Selection Change
For various reasons, I would prefer to use vba as opposed to
conditional formatting for my worksheet. If a duplicate value (in this case, lengthy text entries) exists, change the font color to blue. I can successfully write the macro for it but again, I would prefer that it fire automatically on the Worksheet Selection Change and I just can't figure how to make that work. "=COUNTIF($D$1:$D$1000,D1)1" Any assistance greatly appreciated as always. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
| change font color | New Users to Excel | |||
| how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
| How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
| Why doesn't the font color change? | Excel Programming | |||
Threaded Mode
