Thread: Using If then to change cell colors in Excel 2007
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Using If then to change cell colors in Excel 2007
Two options, either Conditional Formatting or Custom Format.
--
David Biddulph

"Randy" wrote in message
...
I'm creating a worksheet to calculate money.. If the amount is negative I
want Excel to display the number in 'Red'.. If Positive I want to have
Excel
display the number in 'Green'.. I'm sure this can be done I just can't
seem
to figure out how to accomplish this
--
Randy


Reply With QuoteReply With Quote