View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Rook[_2_] The Rook[_2_] is offline
external usenet poster
 
Posts: 70
Default Conditional Formatting

I am currently using the 4 traffic light icon set to conditionally format my
cells. the conditions are if a number is between x & y condition z, there
are many diffent variants.

What I would like to do is also show the number that has been entered. ie if
any this below 10 shows a red cirlce, if I enter 2 I would like to see a red
circle with the number 2 inside.

Can this be done eaisly?

Regards