Alert If Cell Value Is a Certain Value

G

Guest

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
 
B

Bob Phillips

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFill a cell with a value 1
Question about conditional formatting of zeros in Excel 0
ACTIVATING A SOUND ALERT ON CELL VALUE 10
Macro to highlight an entire row if a certain value is in a cell 1
How do I HIGHLIGHT a cell if it is smaller than a value X? 2
how to highlight more related cells if cell highlight 5
What 'value' is a Dec2Bin output? 9
If a cell contains a certain value 1

Top