# Conditional Format Question

#### Bill_Biggs

##### Well-known Member
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?

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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.

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

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.

Thanks to all of you.

Replies
1
Views
328
Replies
2
Views
315
Replies
4
Views
203
Replies
16
Views
401
Replies
4
Views
149

1,220,978
Messages
6,157,180
Members
451,402
Latest member
Lyv

### 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.

### Which adblocker are you using?

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

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