Hi, Can I use the if function to change the cell color , say if I say if cell
a5 = 28 aug 06 then turn cell a5 green , can any one give me an idea how to
do this.

Thanks in advance, Wildauk.

One way to do that is conditional formating. (Found under the Format
menu, "Conditional Formating")

Charles
wildauk wrote:
Hi, Can I use the if function to change the cell color , say if I say if cell
a5 = 28 aug 06 then turn cell a5 green , can any one give me an idea how to
do this.

Thanks in advance, Wildauk.