Conditional formatting
 

Hello,

in Excel 2003, how do I make the following:

if the number in cell in Column 1 is found in Column 2 AND in Column 3, do
some formatting... The point is - I know how to make the conditions, but how
do I impose the 'AND' paradigm between both? That is - do the formatting only
if both conditions hold true...aren't the conditions OR'd by default? Thanks!

Conditional formatting
 

Try it with a formula

=AND(A1=A2,A1=A3)


--
HTH,
Barb Reinhardt



"Mac" wrote:

Hello,

in Excel 2003, how do I make the following:

if the number in cell in Column 1 is found in Column 2 AND in Column 3, do
some formatting... The point is - I know how to make the conditions, but how
do I impose the 'AND' paradigm between both? That is - do the formatting only
if both conditions hold true...aren't the conditions OR'd by default? Thanks!

Conditional formatting
 

In the Conditional Formatting dialogue box, select Formula Is rather
than Cell Value Is in the first box, and then enter this formula in
the next box:

=AND(A1=B1,B1=C1)

then click on the Format button and set your format to suit.

Hope this helps.

Pete

On Mar 29, 12:21*pm, Mac wrote:
Hello,

in Excel 2003, how do I make the following:

if the number in cell in Column 1 is found in Column 2 AND in Column 3, do
some formatting... The point is - I know how to make the conditions, but how
do I impose the 'AND' paradigm between both? That is - do the formatting only
if both conditions hold true...aren't the conditions OR'd by default? Thanks!

Conditional formatting
 

Thanks, that'll be it. One more point - instead of comparing against one cell
(B1), I need comparing against a range (R1C2:2150C2); wouldn't a lookup
function be better for this? If so, which one?

"Pete_UK" wrote:

In the Conditional Formatting dialogue box, select Formula Is rather
than Cell Value Is in the first box, and then enter this formula in
the next box:

=AND(A1=B1,B1=C1)

then click on the Format button and set your format to suit.

Hope this helps.

Pete

On Mar 29, 12:21 pm, Mac wrote:
Hello,

in Excel 2003, how do I make the following:

if the number in cell in Column 1 is found in Column 2 AND in Column 3, do
some formatting... The point is - I know how to make the conditions, but how
do I impose the 'AND' paradigm between both? That is - do the formatting only
if both conditions hold true...aren't the conditions OR'd by default? Thanks!