View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andrew[_54_] Andrew[_54_] is offline
external usenet poster
 
Posts: 3
Default "how do i use color with if in exel"

Mohamad,

Set the colour of the cells to Red.

Then use conditional formatting (Format - Conditional Formatting) for
the cell, setting up a condition that if the cell contents is less than
0 colour the cell yellow.

Make sense?

Andrew