Conditional formatting.

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SteveLincoln" wrote in message
...
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