Hi,
I have a simple Yes/No drop down list that changes the cell colour (red & green) when yes/no is changed, the CF setting seems to work to change the colour but then fails after a few attempts and shows both red & green.
If i slightly adjust the column width then the CF works ok.
Is there some sort of bug / fault and if so is there a workaround with another formula ( maybe isblank or something) or any other method.
Further instructions in the enclosed example file.
Regards
Garry
Bookmarks