Row Colour based upon Multiple Conditions.

[JonPB]

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

 

[phantom1975]

You won't need to use an IF formula in your conditional formatting. You have the ability for 3 different conditions for your conditional formatting. Keep in mind that Condition 1 has priority over Condition 2 and so on. You will probably want to use cell data rather than a formula to set the conditions. You can then copy and paste the formatting once you have it done in one cell so that it applies to an entire row.