Hi all,
I've not used MS Excel for ages, and have now forgotten how to basically use its advanced features. I have a worksheet (http://jonnyb.homeip.net/databasedemo/package8.xls) I have inserted many auto sums and would now like to create a conditional formatting for the rows. I have tried the conditional formatting and formula auto-dialogs but its not working for me.
I have two columns in the worksheet 'Needed Finance' and 'Original Amount Borrowed' I would like it so if the Amount borrowed is less than or equal to the Needed Finance then the row turns GREEN.
Or if the Original Rate<= Flat Rate then row GREEN
But if
Original Amount Borrowed is > needed Finance and Original Rate< Flat Rate to be ORANGE, else
all other rows are RED.
Any ideas or help on this matter would be very gratefully appreciated,
I would use a nested IF, if I knew where to put it and what the reserved words were
Thank you
Jon.
_________________
"Smoke me a kipper, I'll be back for breakfast!"
This message was edited by JonPB on 2002-10-30 09:22
I've not used MS Excel for ages, and have now forgotten how to basically use its advanced features. I have a worksheet (http://jonnyb.homeip.net/databasedemo/package8.xls) I have inserted many auto sums and would now like to create a conditional formatting for the rows. I have tried the conditional formatting and formula auto-dialogs but its not working for me.
I have two columns in the worksheet 'Needed Finance' and 'Original Amount Borrowed' I would like it so if the Amount borrowed is less than or equal to the Needed Finance then the row turns GREEN.
Or if the Original Rate<= Flat Rate then row GREEN
But if
Original Amount Borrowed is > needed Finance and Original Rate< Flat Rate to be ORANGE, else
all other rows are RED.
Any ideas or help on this matter would be very gratefully appreciated,
I would use a nested IF, if I knew where to put it and what the reserved words were
Thank you
Jon.
_________________
"Smoke me a kipper, I'll be back for breakfast!"
This message was edited by JonPB on 2002-10-30 09:22