Hi Shazzer,
You may be able to adjust this to your needs.
http://xldynamic.com/source/xld.Colo...r.html#sorting
HTH
Martin
"Shazzer" wrote in message
...
I want to say :-
IF the text in A1 is formatted Red then, "yes" else "no"
Is there any way I can do this?
Ta v much