changing cell colour using based on cell value

Hi all

Is there a way to have the cell colour change based on the number withing the cell.

If for example the cell A1 shows 0 as default, I would to change Cell B1 for example to say red?

Can this be done?

Or is there another way to do it, i.e. by using =if

Cheers

Thanks for the reply.

I've never come across Cond Formatting, I shall have a play with it.

Thanks

Cheers

I have used the Cond Formatting feature and it has solvedd my problem.

Thanks