Excel If/Then Multi-cell conditional formatting

[Lyokofreeze]

Hello everyone, and happy Sunday.

I have an interesting problem on my hands. I work for a gas station, and for our cigg orders, we fax an excel speadsheet to SAMS CLUB. I recently have done some modifications by applying conditional formating to indicate negitive numbers and zeros, however, I am trying to find a way to blank out 2 adjacent cells when a cell = 0.

Here is a sample:

Order# Desc #to order

921934 (brown) Bx 0

The Zero is already whited out in my sheet, however I am trying to find a way to make the Order Number and Desc. be whited out also when the Number to order = 0

If anyone has any ideas on how to accomplish this I would appreciate it.

-Lyoko Cyrus Freasion

[Carim]

Hi,

You use Conditional Formatting as well
if the reference cell is A1, position your self on the cell to "blank out"

select Formula Is
=$a$1=0
Format Patterns White

HTH
Carim

[VBA Noob]

Hi,

Using Conditional Formatting

Select Columns then
Format > Conditional formatting

Say data in Col A and B enter this

=$C2=""

and format cell fonts white

VBA Noob

[Lyokofreeze]

So wait. Which dropdown do I use? Equal to?

[VBA Noob]

See attached for an example of conditional formatting

http://www.contextures.com/xlCondFormat03.html#Errors



VBA Noob

[Carim]

Hi,

I think VBA Noob will agree with me ...
Despite the fact you can achieve your goal with conditional formatting,
it would be more "reasonable" to go the following way ...

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

HTH
Carim

[Lyokofreeze]

That didn't help. When I try to enter that formula, it says there is an error.

[Carim]

Well is your separator ; instead of , ... ?

HTH
Carim

[VBA Noob]

Carim,

Easier when they post the example

This 2nd guessing gets a bit boring at times

VBA Noob

[Carim]

VBA Noob,

Could'nt agree more ...

[Lyokofreeze]

Alright. Here is what it looks like.

[Carim]

Ok then ...

In cell A5, use conditional formatting
in the area Condition1 select Formula Is
in the formula area type following

Please Login or Register  to view this content.

then select Format Fonts White

Is it working as expected ?

HTH
Carim

[Lyokofreeze]

Ok. That worked for column A. Now what about B? It doesn't fill correctly.

[Carim]

In order to apply the same conditions to cell B5 ...
repeat the same process ...¨
the only difference is a small change in the formula

Please Login or Register  to view this content.

As far as extending these conditions to all your data, use the Format Painter
( the icon which looks like a yellow brush ...)

HTH
Carim

[Lyokofreeze]

Ok, that worked, now one last question, is there a way to make a list on a third sheet that only lists the Non-Whitedout cells? Or is that too complex?

[Carim]

Glad your problem is fixed.

Thanks for the feedback

Carim

[Lyokofreeze]

So is there a way to automaticly make a form/list of the data in the non-whited out cells on another sheet, So that it is grouped together and whatnot?