Thread: Coloring cells based on positive or negitive numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Coloring cells based on positive or negitive numbers
Checkout conditional formatting:

http://www.contextures.com/xlCondFormat01.html
--
Gary''s Student - gsnu200753


"Florida Richard" wrote:

I have a worksheet that I would like to set up so if the number in a
particular cell is a positive number the cell is green. If the cell has a
negitive number the cell turns red. All of the cells in question are in the
"R" column and are in %.

Thank You.
Reply With QuoteReply With Quote