View Single Post
 
Old 12-11-2014, 12:44 PM
mikey386 mikey386 is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Dec 2014
Posts: 10
mikey386 is on a distinguished road
Default Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N

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
Reply With Quote