Use the FormulaIs option:

=A1=13
or whatever
--
Gary's Student
gsnu200707


"Tom" wrote:

Hi,

I'm trying to do conditional formatting of a cell dependent on the input of
a different cell.

i.e - Format cell B1 dependent on the input of cell A1

Can anybody help me in how to do this ??

Thanks
Tom