Excel Help re Conditional Format

[PermaChanged]

Hi all,

This is probably a very basic problem which I'm over thinking but I have a column in excel with the cells formatted for currency, so if they are negative they are red, positives are black.

What I want is the rest of the row to be the same colour as the amounts, so the whole row where there is a negative balance the text needs to be red, positive is black.

Hope you can help!

 

[PermaChanged]

Thanks Sweey, that has pointed me in the right direction. But what happens when I need it to carry on all the way down the sheet? Do I need to make a conditional format for every row?

 

[PermaChanged]

It's not working like that unfortunately.

Say if A1 is my currency value and B1 is the cell I want to change colour I use the conditional format in B1 =$A$1<0 Red =$A$1>0 Black.

My next currency is in A2 so I need a different conditional format in B2, =$A$1<0 Red =$A$2>0 Black.

I can't use =$A$1:$A$100 though, it's just not working.