Conditional formatting - Borders

Hi
I have only just found out about conditional formatting (thanks to this forum!)
i am trying to do the following but having trouble getting my head around it!

if a2=0 then b2:b13=border

Any help is greatly appreciated!!!

Thanks

Select B2:B13 and go to Format|Conditional Formatting

Then pick Formula Is from the first drop down menu and enter formula

=$A2=0

Click Format and choose your borders from the Borders tab.

Strange- I couldn't see a reason it wasn't working either so I deleted the rule and reapplied it.

See the attached version.

So what's it supposed to look like? Are you colouring all cells in A2:C9 based on value only in A1?

Then select A2:C9 and edit the Condition Rule to read:

=AND(ISNUMBER(A2),$A$1=1)

this will highlight all the cells with a number in it only when A1=1.

if you want to colour the blanks too... then formula is: =$A$1=1

The formula in C4 is not giving the number 1, it is giving the text string "1"... change the formula to:

=IF(B4="",3,1)

Note:

If you want to apply this condition on all rows, take the $ sign away from before the 4 in $C$4 in your conditional format... then you can copy that formatting to the remaining rows....

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save