Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-11-2014, 12:44 PM
mikey386 mikey386 is offline Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N Windows 8 Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N Office 2010 64bit
Novice
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N
 
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
  #2  
Old 12-11-2014, 01:00 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now Need help with conditional formatting &amp; returning &quot;Pass&quot; / &quot;Fail Results&quot; in a Column N Windows 7 64bit Need help with conditional formatting &amp; returning &quot;Pass&quot; / &quot;Fail Results&quot; in a Column N Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
external links are potentially unsafe. Please post a sample sheet on the forum - Thx
__________________
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
Reply With Quote
  #3  
Old 12-11-2014, 01:14 PM
mikey386 mikey386 is offline Need help with conditional formatting &amp; returning &quot;Pass&quot; / &quot;Fail Results&quot; in a Column N Windows 8 Need help with conditional formatting &amp; returning &quot;Pass&quot; / &quot;Fail Results&quot; in a Column N Office 2010 64bit
Novice
Need help with conditional formatting &amp; returning &quot;Pass&quot; / &quot;Fail Results&quot; in a Column N
 
Join Date: Dec 2014
Posts: 10
mikey386 is on a distinguished road
Default Ok - Sorry for that -

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
remove repeated words with " macro " or " wild cards " in texts with parentheses and commas jocke321 Word VBA 2 12-10-2014 11:27 AM
Need help with conditional formatting &amp; returning &quot;Pass&quot; / &quot;Fail Results&quot; in a Column N Numbering format not "tracked" in track changes w/ formatting "on." Velocitydreamer Word 1 05-26-2013 07:04 AM
Conditional formatting - "From" - Why does it recognise only names and not emails ghumdinger Outlook 0 09-18-2011 01:28 AM
How to edit the "Format" and the "show level" of an EXISTING table of content? Jamal NUMAN Word 2 08-14-2011 10:46 AM
Need help with conditional formatting &amp; returning &quot;Pass&quot; / &quot;Fail Results&quot; in a Column N How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft