Conditional Format Question

Bill_Biggs

Well-known Member
Joined
Feb 6, 2007
Messages
1,216
I have a cell that turns red if it value is less than 10, otherwise it turns green. But I have another cell on another page that impacts the value of the cell in question. If the value of the second cell is greater than 3, I need the first cell to ignore the first two conditions and turn blue. Can some one help me with this? :eek:
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
You need to add a third condition to your conditional formatting. Open your existing conditional format dialog box and click "Add" to create another condition.
Actually, since you want your cell to ignore the first two conditions you need to make this new condition the first one and put the other two after it.
Since you have not explained exactly what worksheet and what cell your "second cell" is, I can not build the formula for you. You should be able to create the new condition based on the example of your other two conditions.
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
24,318
You only need 2 conditions.

Normal = Green

condition 1) if othercell>3 then blue (custom formula =($X$1>3))

condition 2) if thiscell<10 then red
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Bill_Biggs:

Following up on Datsmart's suggestion ...

Let us say the other sheet cell that you refered to is F4 in Sheet 3 ...
Book2
EFGH
3
43
5
Sheet3


and the cell to be Conditionally Formatted is cell B2 in the ActiveSheet ...
Book2
ABCD
1
210
3
Sheet5


Then I would first make the background color of cell B2 GREEN, and then use the following two conditions for Conditional Formatting ( with cell B2 as the ActiveCell) ...

1) formula is ... =INDIRECT("Sheet3!F4")>3 ... color BLUE

2) cell value is ... less than 10 ... color =RED

Note For condition 1, you may optionally assign a RangeName such as OtherSheetCell and use that instead of INDIRECT("Sheet3!F4")

I hope this helps.
 

Forum statistics

Threads
1,181,658
Messages
5,931,268
Members
436,785
Latest member
KingGideon

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