Hi,
I have a Range of Data that has a normal Font Color of Black, however there is a Conditional Format in place to Change the Font to Red if that Value is not in a specific list. This all works fine but I want to be able to check if any of the values are in Red Text before a macro runs and if...