How to enter formula to give warnings

[Chris]

How can I get a cell to give required warnings if other cells are out of range.

Warnings to show in Cell M8.

Cells B8= 1960 C8= 1860 B39= 81 . I need cell M8 to show 1 of 3
statements.
Statement 1 if C8 is greater than B8 less 100, show. Check lenght.
Statement 2 if C8 is less than B9 less 100 but greater than B39, show.
Lenght OK.
Statement 3 if C8 is less than B39, show. Check length/depth.
Statements 1 & 3 to be in red and statement 2 to be green.
Thanks
Chris

 

[Per Jessen]

Hi Chris

Use this formula in M8 to show the warnings, and use conditional formatting
to color the cell.

=IF(C8>B8-100,"Check length",IF(AND(C8<B9-100,C8>B39),"Length
OK",IF(C8<B39,"Check leght/depth","")))

Hopes this helps.
....
Per

 

[Max]

One way

In M8:
=IF(C8>B8-100,"Check Length",IF(AND(C8<B9-100,C8>B39),"Length
OK",IF(C8<B39,"Check length/depth","")))

Then select M8, apply CF using Formula Is:
Cond1: =OR(M8="Check Length",M8="Check length/depth")
Format>Font tab>Red

Cond2: =M8="Length OK"
Format>Font tab>Green
Click to OK out

Success? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik