Change of text color when drop down box is changed

hii

I am attaching an excel sheet for a clear demonstration of my problem.

Here In the ""ALL ENTRIES FLAGGED"" tab starting from L22 TO L53,each is having a drop down with the following items.

1.Yes.but only closing entries with the selected characteristics.
2.yes,all closing entries
3. No

So when the user clicks in the drop down and changes from either of the yes(any of the two yeses in the drop down list) to NO in the drop down,then text in K8 and K9 should be displayed in red.

So the user should be able to remember its previous state and the present state in order for the color to change to red in the search/selection criterion column.

IF its initially NO and then changed to either of the YESES then the text in the search/selection criterion TEXT should NOT be coloured to RED.It should be as it is(which is black).

Originally Posted by Trebor76

Hi there,

You don't need code to do this - conditional formatting does the job (refer attached).

Regards,

Robert

thanks a lot!!