Alert If Cell Value Is a Certain Value

S

SteveLincoln

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

2007 conditional formatting not playing ball 5
Activating a sound alert on cell value 0
Add value of (1) to a selected cell or cells 2
Macro to highlight an entire row if a certain value is in a cell 1
AutoFill a cell with a value 1
ACTIVATING A SOUND ALERT ON CELL VALUE 10
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Add numbers if cell fill is a certain color; How To? 5

Top