Hi Everyone

How can U set up an alert to format cells with a pink fill colour if say A1
ever has the value eg 1000 in it?

This could be used to Highlight the Name and address of someone (with a pink
fill) that has ever owed £1000 even if they now do not.

In other words the name and address of that person stays in pink fill if
ever they have owed £1000.


Thanks for any help.
Steve
Lincoln
UK


turn cells get Excel record that a cell has ever been a certain value