Conditional Formatting Help

[MrTrent]

Hi,

Lets say I have 2 Cells...

Cell A1 & B1

In A1 it has a "1" in it. In B1 it has a "0" in it... How do I possibly make it so if B1 gets a "1" in it, Both Cells work together and Highlights the Numbers, or do some for of Conditional Formatting?

I thought doing something like =(A1:B1)>0 would do the trick, but no..
I have tried other things too...

With saying it equalling to 1, what I am actually is, if both of them are above Zero it will Conditional Format.. So it could be A1 "1" B1 "20" and it will still be Red. As soon as either one goes to Zero, it goes back to normal color etc.

 

[MarcelBeug]

=and(a1>0,b1>0)

 

[MrTrent]

=and(a1>0,b1>0)

Strangely that still only does the one side...
I will also be doing it a big range, say A1:B236

 

[MarcelBeug]

Ah, sorry. It must be:

=AND($A1>0,$B1>0)

If you first select your range (A1:B236) and then enter your conditional formatting with this formula, it should be OK.

 

[SpillerBD]

I used Absolute referencing and relative referencing and both worked for me.
Double check the cells the rule is applied to...

 

[MrTrent]

Ah, sorry. It must be:

=AND($A1>0,$B1>0)

If you first select your range (A1:B236) and then enter your conditional formatting with this formula, it should be OK.

This one worked perfectly... Thank you... Has saved me a lot of time...