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

Formula for showing warnings when cells are out of range.
 

Please don't multi-post. Check response to your posting in .newusers
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Chris" wrote:
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