Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JayF
 
Posts: n/a
Default Conditional Formatting for a range situation

Attempting to write a conditional format as follows:
1) Green if value in cell is +/- or = 2.5% {example 97.5% to 102.5% = Green}
2) Yellow if value in cell is +/- 2.5% and < = 5.0% {example 97.4% to 95.0%
and 102.6 to 105.0 = Yellow)
3) Red if value in cell +/- 5% {example 94.9% and less and 105.1% and
higher = red.

I am using Conditional Formatting with condition #1 = Formual is
'AND(+b40.9749,+b4<1.0251)'. Question. How do I write the next two
conditions? Is there a logic stmt for less then and equal? Greater then or
equal. I am new at this. Hope there is a template for this type of
Conditional formatting.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default Conditional Formatting for a range situation

Since the conditional formatting is applied in the order of the conditions,
you can simply use the second range in the 2d condition, like so

=AND(+b40.949,+b4<1.051)

and the last range in the 3rd condition



"JayF" wrote:

Attempting to write a conditional format as follows:
1) Green if value in cell is +/- or = 2.5% {example 97.5% to 102.5% = Green}
2) Yellow if value in cell is +/- 2.5% and < = 5.0% {example 97.4% to 95.0%
and 102.6 to 105.0 = Yellow)
3) Red if value in cell +/- 5% {example 94.9% and less and 105.1% and
higher = red.

I am using Conditional Formatting with condition #1 = Formual is
'AND(+b40.9749,+b4<1.0251)'. Question. How do I write the next two
conditions? Is there a logic stmt for less then and equal? Greater then or
equal. I am new at this. Hope there is a template for this type of
Conditional formatting.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Conditional Formatting for a range situation


Here's one way

condition 1 red
=(B4<"")*(ABS(B4-1)0.05)

condition 2 yellow
=(B4<"")*(ABS(B4-1)0.025)

condition 3 green
=(B4<"")*(ABS(B4-1)0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527766

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default Conditional Formatting for a range situation


Here's one way

condition 1 red
=(B4<"")*(ABS(B4-1)0.05)

condition 2 yellow
=(B4<"")*(ABS(B4-1)0.025)

condition 3 green
=(B4<"")*(ABS(B4-1)0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527766

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JayF
 
Posts: n/a
Default Conditional Formatting for a range situation

Excellent. Simple and direct...I like it

"daddylonglegs" wrote:


Here's one way

condition 1 red
=(B4<"")*(ABS(B4-1)0.05)

condition 2 yellow
=(B4<"")*(ABS(B4-1)0.025)

condition 3 green
=(B4<"")*(ABS(B4-1)0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=527766


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
Conditional Formatting - Formulas meandmyhorse Excel Discussion (Misc queries) 2 February 18th 06 01:58 PM
Need to make a "range" in conditional formatting. DocMartigan Excel Discussion (Misc queries) 3 October 7th 05 04:19 AM
Conditional Formatting - Lookup Range murphyz Excel Discussion (Misc queries) 8 August 24th 05 03:55 PM
Conditional Formatting Error ddate Excel Worksheet Functions 0 May 5th 05 09:00 PM
conditional formatting conflict? Abi Excel Worksheet Functions 2 January 11th 05 04:41 PM


All times are GMT +1. The time now is 05:23 PM.

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

About Us

"It's about Microsoft Excel"