Thread: can colors be used in if test results eg red for minus amounts
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PJFry PJFry is offline
external usenet poster
  
Posts: 143
Default can colors be used in if test results eg red for minus amounts
Yes. Check out Conditional Formating.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"JOHN13" wrote:

IN WRITING IF TESTS IWOULD LIKE TO HAVE THE RESULT PRINT IN RED FOR NEGATIVE
NUMBERS AND BLACK OR GREEN FOR POSITIVE. CAN THIS BE DONE.
Reply With QuoteReply With Quote