View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
gibbylinks gibbylinks is offline
external usenet poster
 
Posts: 23
Default Conditional Format Text - Yes/No

I've looked at conditional formatting. I used to be able to fly this under
the old versions, but (sorry should have said) I'm using Office 2007 and I
can't see how to apply it to jus tone cell !!

Very confusing

"Rob Wills" wrote:

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