Coloring Cells based on formula's result - is it possible ?

allanTeh

New Member
Joined
Jun 29, 2006
Messages
43
As example, I have 4 columns (from Cell A1 to Cell D1) that store data as follows:

Macedonia 0 1 England

(Columns B and C are numerical)

I want to do a formula/function that will check which Column (B or C) have higher value - if B1 > C1, highlight Cell A1 with green background, if B1 < C1, highlight D1 with green background, if B1 = C1, highlight both A1 and D1 with yellow background.

Is that possible in Ms Excel ?
If not, any other software that have that ability ?
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Hi Allan,

You can do this with Conditional Formatting

1. Select values in Column B
2. Format > Conditional Formatting
3. Instead of Cell Value Is, change to Formula Is
In the formula bar, put =$B1>$C1
Click the Format button
On the Patterns tab, select green
OK
4. Back in the dialog, press Add.
5. This time, Formula Is =$B1=$C1
Change Pattern to yellow
OK
OK

Select Column C values, repeat and adjust formulas where required

Denis
 

allanTeh

New Member
Joined
Jun 29, 2006
Messages
43
Good Simple Solution - THANK YOU !

The solution given by Mr SydneyGeek is very easy to use. It's simple and straight-forward.

A big THANK YOU to Mr SydneyGeek !
Cheers !
 

Forum statistics

Threads
1,137,298
Messages
5,680,689
Members
419,927
Latest member
Axtros

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