Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 19th 10, 04:52 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 6
Default Using Conditional Formatting to Pass/Fail

I want to use conditional formatting to return a pass fail number based on a
numeric value. However the number has to fall between 2 values. i.e A product
will pass if the numeric value it achieves is between 2 and 8 but if the
value is less than 2 or greater than 8 it will fail. I can't seem to get the
if statement to understand the concept of pass being between 2 and 8.
--
mrsatroy

  #2   Report Post  
Old April 19th 10, 05:01 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,942
Default Using Conditional Formatting to Pass/Fail

Conditonal formats return formats and not numbers. The CF should be farily
easy. if Cell value is not Between 2 and 8 then add your pattern. If you want
a value returned then in a differnet cell use a formula something like

=IF(AND(A1=2, A1<=8), 1, 0)
--
HTH...

Jim Thomlinson


"mrsatroy" wrote:

I want to use conditional formatting to return a pass fail number based on a
numeric value. However the number has to fall between 2 values. i.e A product
will pass if the numeric value it achieves is between 2 and 8 but if the
value is less than 2 or greater than 8 it will fail. I can't seem to get the
if statement to understand the concept of pass being between 2 and 8.
--
mrsatroy

  #3   Report Post  
Old April 19th 10, 05:05 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2009
Posts: 18
Default Using Conditional Formatting to Pass/Fail

Assuming you got your values in column B, starting in B2:

The formula for the pass-rule
=AND(B2=2,B2<=8)

The formula for the fail-rule
=OR(B2<2,B28)

"mrsatroy" wrote:

I want to use conditional formatting to return a pass fail number based on a
numeric value. However the number has to fall between 2 values. i.e A product
will pass if the numeric value it achieves is between 2 and 8 but if the
value is less than 2 or greater than 8 it will fail. I can't seem to get the
if statement to understand the concept of pass being between 2 and 8.
--
mrsatroy



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula help - Sum results Pass or Fail Nadine Excel Worksheet Functions 9 August 6th 13 10:20 AM
Creating a pass of fail condition jhumphreys New Users to Excel 6 July 7th 09 01:26 AM
Graphing Text: Pass or Fail Robert Charts and Charting in Excel 3 April 12th 09 11:41 PM
Pass or Fail (green or red) criteria for cell? Pheasant Plucker® Excel Discussion (Misc queries) 6 January 27th 06 06:47 AM
pass fail Tricia New Users to Excel 3 January 20th 05 03:45 PM


All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017