| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for showing warnings when cells are out of range.
How do I write the formula so it will tell me when another cell input is out
of Range. eg B8 may be 1960 and C8 can not be any more than 1860 or less than B39 which may be 81. If C8= 1861 or more M8 should show, "Check Length", in red. If C8= less than 1860 but more than B39 (=81) show, "Lenght OK", in green. If C8= less than 81, I need it to show, "Check Lenght/Depth, in red. Thanks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to enter formula to give warnings | New Users to Excel | |||
| How to fix my spreadsheet from showing formula to showing answer | Excel Discussion (Misc queries) | |||
| How to fix my spreadsheet from showing formula to showing answer | Excel Discussion (Misc queries) | |||
| count number of cells in range showing between 320 and 345 | Excel Worksheet Functions | |||
| Showing Zero for all blank cells in a range | Excel Discussion (Misc queries) | |||
Threaded Mode
