View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rob Wills Rob Wills is offline
external usenet poster
 
Posts: 18
Default Conditional Format Text - Yes/No

Hi

Have a look at Conditional formatting

HTH
Rob
===================

"gibbylinks" wrote:

I have a drop down box with YES/NO. I want to turn the text to RED if "Yes"
is selected and Blue if "No" is selected.

How do I apply it to the one cell ?

Thanks