code to change color of negative cell
 

I am creating a table with percentages and I want it to make the
negative %s red. How would I code/format for this?

Thanks,
Jackie

code to change color of negative cell
 

do a custom number format (format=cells=Number Tab then Custom)

0.0%;[Red]0.0%


--
Regards,
Tom Ogilvy


" wrote:

I am creating a table with percentages and I want it to make the
negative %s red. How would I code/format for this?

Thanks,
Jackie