More issues with this - Is there a way to ensure the following -
I need
Any values between D18:M37 that are
blank to show as red -
To ensure that if any cells in the array D18:M37 contain
red fill formatting will show as a failed result and cause the column to "Fail" .
Anything values - including text - that are equal to or between the MIN and MAX to register as "PASS" (White) - and anything outside of the scope to register as "FAIL" (Red)
Any cell in *columns* 18 - 37 within the range D18:M37 - that have red formatting need to be able to return a "FAIL" result in the corresponding cell in column N <-- this may be super redundant - but I'm trying to be as descript as possible.
Here is the link for what I presently have
https://app.box.com/s/1ownzq4y887m1w6ovcdc
This has been THOROUGHLY frustrating - I've been told this was almost perfect - *sigh*
I am GREATLY appreciative of any help