ExcelBanter - Excel 2000 - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2000 - Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/131613-re-excel-2000-conditional-formatting.html)

Gary''s Student

Excel 2000 - Conditional Formatting

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

All times are GMT +1. The time now is 11:49 AM.