View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Coloring cells based on positive or negitive numbers

Click, Format, Conditional formatting

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.