conditional formatting question

[buachille]

hello,

i transfer bank statements to excel for later reference, and in one of
them i would like to conditionally format the whole row to be red (or
if this is not possible then the relevant cell) if the payment box
contains a minus sign.

so, if we have payed out £50, in my excel bank statement it shows as
-£50. i'd like excel to pick that up and format the whole row, or just
the cell, to be red.

now i can't find the option in conditional formatting, so i am starting
to think it will be a sumproduct job - but i have no idea how i would
write this formula.

can anyone help please

thanks for any replies

 

[SteveG]

Select the entire row you want to apply the format to. Assuming the
value you are looking at is in F12. Go to conditional formatting and
enter this formula.


=SIGN($F$12)=-1

or

=F12<0

Click on Format, Patterns, Select Red, OK, OK.

HTH

Steve

 

[Bob Phillips]

select the row, and assuming the amount is in column C, use CF with a
formula of

=LEFT($C1)="-"

and format accordingly

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)