View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
S.Paul[_2_] S.Paul[_2_] is offline
external usenet poster
 
Posts: 1
Default Conditional formatting

You cannot use "stoplight color" for formatting "text" values. Icon set
formatting is for numbers

"CB" wrote:

I am using 2007

"CB" wrote:

In Column D I have the text Green, red or yellow. My question is how do I
display the Green Stoplight, Red Stoplight or yellow Stoplight?
CB