View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Formatting Conditional Formatting Icon Sets

Hi again,

what you could do is put the values in one column, say column A, and format
column B with your stop lights, but based on the values in column A.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"The Rook" wrote:

I have used the traffic light icon set in conditional formatting so that it
displays both the traffic light and the cells data.

Is it possible to format the traffic light so that it appears on the right
of the data instead of the left.

Regards