Excel 2000 - Conditional Formatting
 

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

Excel 2000 - Conditional Formatting
 

Thanks for the speedy response (Its so simple, I feel abit stupid now lol)

"Gary''s Student" wrote:

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