View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default formating cells using formula rather than menus/VBA

Here are some alternative symbols you could use which look a bit better
than CHAR(12) in Arial:

CHAR(7) - filled circle
CHAR(8) - filled rectangle with hollow circle
CHAR(17) - filled triangle
CHAR(129) - slimmer rectangle than char(12)

You only need to set the colour of the original formula to red once
(when you type it in), then copy down - all of the "bar charts" will
appear red.

Hope this helps.

Pete