B
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
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