[HELP] Color coding cells if data is missing

[vixushr]

Helo,

I have one specific situation wich i dont know how to resolve.

In one row i have several cells, lets say row1 cells A,C,F for example, that need to have a data in it.
Problem is that only one of those 3 needs to have data, no more no less... so do the other 3 (B,D,E aswell).

Is there a way to fill with some color all of those 3 cells if theres no data in any of them so that i i can visualy notice that theres data missing and fix it?

Thank you for your help!

 

[Matty]

Welcome to the Board!

Do you need a warning too if there is more than one value entered in the three Cells, or is this unlikely to happen?

Matty

 

[GTO]

Hi there,

IF it is only a check to see that at least one val is entered, try CF with a formula:

=AND(A1="",C1="",F1="")

 

[vixushr]

Welcome to the Board!

Do you need a warning too if there is more than one value entered in the three Cells, or is this unlikely to happen?

Matty

Helo, thank you for commenting... now that i think of it... that is also a case with some of my cell groups.

 

[vixushr]

Hi there,

IF it is only a check to see that at least one val is entered, try CF with a formula:

=AND(A1="",C1="",F1="")

...how to apply this for all of my rows on sheet?

 

[Matty]

Try this Conditional Formatting formula:

=COUNTA($A1,$C1,$F1)<>1

Then choose a format that you want to show when there is not 1 value in these Cells.

Finally, apply this to the range where you want the formatting applied, so something like:

=$A$1:$A$10,$C$1:$C$10,$F$1:$F$10

Use the same logic for the Cells B, D and E.

Matty

 

[vixushr]

Try this Conditional Formatting formula:

=COUNTA($A1,$C1,$F1)<>1

Then choose a format that you want to show when there is not 1 value in these Cells.

Finally, apply this to the range where you want the formatting applied, so something like:

=$A$1:$A$10,$C$1:$C$10,$F$1:$F$10

Use the same logic for the Cells B, D and E.

Matty

Excelent Matty, works just as it shud!
Thank you, you are lifesaver!

 

[vixushr]

some more help needed!!!

I want to set similar condition:

if cell C is full and cell AC is empty to color code ...

i am trying something like this
=COUNTA($C2)<>0
and that part works
but when i want to add condition for AC cell like this:
=COUNTA($C2)<>0&($AC2)<>1
it yust wont work!

what am i missing here???

 

[vixushr]

anyone?

 

[Matty]

If I follow correctly, try:

=AND(C2<>"",AC2="")

Matty