Formula for showing warnings when cells are out of range.

C

Chris

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
 

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

How to enter formula to give warnings 2
Conditional format won't copy 7
format cells depending on value range 5
Coloring the cells by formula 7
Formula for a range of percentages 6
Excel check if dates are under a range of week 4
Formula using DATES 4
Report one value out of a range 2

Top