Row Colour based upon Multiple Conditions.

JonPB

New Member
Joined
Oct 29, 2002
Messages
9
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
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
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.
 

Forum statistics

Threads
1,144,767
Messages
5,726,177
Members
422,660
Latest member
mrsteele

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top