Conditional Formatting

Opgelost

New Member
Joined
Dec 6, 2014
Messages
44
Dear Friends,

I would like to do the following in B8.

If cell value C8 is equal to or less then 0 then fill cell B8 with GREEN colour

I can do it if it concerns only one cell, e.g. C8, but no it concerns two cells.

Please help.

Thank you in advance,

Opgelost ( The Netherlands)
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Marcílio_Lobão

Well-known Member
Joined
Oct 7, 2013
Messages
777
Office Version
  1. 2007
Platform
  1. Windows
Opgelost, Good evening.

Your explanation is not clear.

What 2 cells are you talking about?

Do you want 2 cells be colored or you want to use 2 cells as criterion?

Please, give us an example of cells and the desired result.
 

dUBBINS

Well-known Member
Joined
Feb 9, 2015
Messages
504
Okay, it sounds like you are familiar with the basics of Conditional Formatting. Choose the cell(s) you want to turn green. When you make a new rule, choose "Use a formula to determine which cells to format". Then in the formula box type in:

=C8<=B8

And format the fill to what shade of green you are after.
 

Opgelost

New Member
Joined
Dec 6, 2014
Messages
44
Okay, it sounds like you are familiar with the basics of Conditional Formatting. Choose the cell(s) you want to turn green. When you make a new rule, choose "Use a formula to determine which cells to format". Then in the formula box type in:

=C8<=B8

And format the fill to what shade of green you are after.
Worksgreatthankyousomuch!
 

dUBBINS

Well-known Member
Joined
Feb 9, 2015
Messages
504
You are quite welcome. I get so much help from this site, it is definitely my pleasure to give back to this community.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,316
Messages
5,623,955
Members
416,002
Latest member
t10k14

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