View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rajan Lengde Rajan Lengde is offline
external usenet poster
 
Posts: 5
Default color text base of value of the formula

Use options in Menu
format/conditional fomrting

"Joe" wrote in message
...
Hi,

Is there a way to make the results of a formula in a cell a certain color
(red, green... etc) base on the results of the forumla (below zero its
red,
above, its green). And if its above 50 its dark green? below
-50 its pink?