conditional formatting

nancyo · Apr 23rd, 2002, 08:23 AM

I am just learning how to set up conditional formatting, can set up to three conditions. Is there any way to make the three conditions an OR situation rather than and AND situation? Probably a very stupid question...

Mark W. · Apr 23rd, 2002, 08:30 AM

Sure....

=OR(A1=1,A1=2,A1=3)

nancyo · Apr 23rd, 2002, 12:26 PM

ok...where does this formula go?

Brian from Maui · Apr 23rd, 2002, 12:30 PM

Click on the cell you want the formatting to go. Then go to Format/Conditional Formatting. Click Formula is, enter the formula, set your patterns and font color, click OK OK.

Sorry Mark for jumping in.

nancyo · Apr 23rd, 2002, 12:46 PM

OK - maybe I am not being clear.

The first condition is actually a specification (i.e. if cell value in A1 <600, then COLOR). The value is the result of a formula in cell A1.

The second condition is if the result in cell A1 is text (the result of one part of the formula - I.E. =IF(ISBLANK(),"na",(FORMULA).If "na" is the result in the cell, then I want a different color.

Does this make sense?

Mark W. · Apr 23rd, 2002, 12:49 PM

See the Excel Help Index topic for "Highlight data that meets conditions you specify".

nancyo · Apr 23rd, 2002, 12:56 PM

Will give it a shot...thanks!

nancyo · Apr 23rd, 2002, 01:27 PM

OK - I checked out the help. The trick was the ORDER of the conditional formats (I suspect), as what I tried worked fine this time. THANKS TO ALL!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 08:23 AM	#1
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	I am just learning how to set up conditional formatting, can set up to three conditions. Is there any way to make the three conditions an OR situation rather than and AND situation? Probably a very stupid question...

Apr 23rd, 2002, 08:30 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Sure.... =OR(A1=1,A1=2,A1=3)

Apr 23rd, 2002, 12:26 PM	#3
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	ok...where does this formula go?

Apr 23rd, 2002, 12:30 PM	#4
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Click on the cell you want the formatting to go. Then go to Format/Conditional Formatting. Click Formula is, enter the formula, set your patterns and font color, click OK OK. Sorry Mark for jumping in.

Apr 23rd, 2002, 12:46 PM	#5
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	OK - maybe I am not being clear. The first condition is actually a specification (i.e. if cell value in A1 <600, then COLOR). The value is the result of a formula in cell A1. The second condition is if the result in cell A1 is text (the result of one part of the formula - I.E. =IF(ISBLANK(),"na",(FORMULA).If "na" is the result in the cell, then I want a different color. Does this make sense?

Apr 23rd, 2002, 12:49 PM	#6
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See the Excel Help Index topic for "Highlight data that meets conditions you specify".

Apr 23rd, 2002, 12:56 PM	#7
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	Will give it a shot...thanks!

Apr 23rd, 2002, 01:27 PM	#8
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	OK - I checked out the help. The trick was the ORDER of the conditional formats (I suspect), as what I tried worked fine this time. THANKS TO ALL!!!