Conditional Formatting

[Acoustic]

Hi there, i have, hopefully, a simple one which i cant find how to do anywhere, all i want to do is shade a cell a particular colour, if 3 other cells all contain a zero.

 

[T. Valko]

Hi there, i have, hopefully, a simple one which i cant find how to do anywhere, all i want to do is shade a cell a particular colour, if 3 other cells all contain a zero.

What cell do you want to shade?
What are the 3 other cells?
What version of Excel are you using?

 

[gobishg]

Use Conditional Formatting in Excel

Select the rule "Use a Formula to determine which cells to format" and use this formula =AND($C$6=0,$A$6=0,$B$6=0). Change the absolute referencing Accordingly

 

[Acoustic]

thankyou very much, wow that was quick.

 

[T. Valko]

Use Conditional Formatting in Excel

Select the rule "Use a Formula to determine which cells to format" and use this formula =AND($C$6=0,$A$6=0,$B$6=0). Change the absolute referencing Accordingly

If the cells are empty they will evaluate to 0. So, you need to make sure the cells actually contain numeric 0.

=COUNTIF(A6:C6,0)=3

 

[Acoustic]

hahaha that answers my very next question, thanks again