In my sheet, I keep my primary column font color "Red" until we take the first action. At that time I manually change the color to "Black". I do not have any conditional formatting that has any control over that column. I do have other columns that do have conditional formatting controlling them.
Here is the strange part.. in one of my columns that is controlled by conditional formatting and has a list drop down to select from. There is one item in the list "Walk In" that for some reason changes the font color of the primary column to "Black". It is the most bizzar thing I have ever come across, It took me a really long time to figure it out. I even deleted the row and re-entered it on a new line and it kept doing the same thing. So, I tried changing some of the other line items on the sheet to the "Walk In" and sure enough, it changed the color of the font in the primary column to "Black". To make it even stranger, if I create a new sheet form the old one, it doesn't happen anymore. Anyway, I guess my solution is to just create a new sheet and go from there but has anyone else run into anything like this?
