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

Hi
external links are potentially unsafe. Please post a sample sheet on the forum - Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

How would I be able to show the formulas within the spreadsheet?