-Hello,

What is the macro for changing the font color in a specific range based on
the text entered? For instance, if user types in "Completed" into any cell in
range B7:B175 the cell with completed should change the text color to green.
I already have 3 allowable conditional formats in place so I need to write
two more macros so I cover all 5 scenarios.

Thanks,
BearsFan