| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Alert If Cell Value Is a Certain Value
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
