i want to use colors in many "Cells" when i use "IF", for example if A1<0 i
want the color of A4 is yellow, else is REd

Hi Mohamad,

You should use Excel's Conditional Formatting featu

Format | Conditional Formatting ...

You may wish to visit Debra Dalgleish's Conditional Formatting tutorial at:

http://www.contextures.com/xlCondFormat01.html

---
Regards,
Norman


"mohamad" wrote in message
...
i want to use colors in many "Cells" when i use "IF", for example if A1<0 i
want the color of A4 is yellow, else is REd

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