Conditional Format Question

[Bill_Biggs]

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?

 

[Datsmart]

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]

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]

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
	E	F	G	H
3
4		3
5
Sheet3

and the cell to be Conditionally Formatted is cell B2 in the ActiveSheet ...

Book2
	A	B	C	D
1
2		10
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.

 

[Bill_Biggs]

Thanks to all of you.