Conditional formatting using values in multiple cells

[Cherian George]

Hi All - I'm not sure if this is possible but would like to pick your experience and knowledge to see what could be done...

I'm trying to apply a conditional formatting on a column.. to change the cell color when it meets the below conditions:

Condition 1. Cells in the column where we have conditional formatting applied should be more than 0
AND
Condition 2. Value in the adjacent cell in the same row should be a fixed text
AND
Condition 3. Value in a fixed cell anywhere in the file should be a fixed text.

Example:
I have texts in cell A3, A6, A7, A9.... = Deployed
I have text in cell B2 = Not Deployed
I have text in cell C2 and D2 = Deployed
and the cells in column D randomly 0 or more

I need to have conditional formatting applied in column D, the conditions should be as mentioned above... If I'm looking at Cell D3, if the value is more than 0, if the value in D2 = Deployed and if the value in A3 is Deployed, then the cell D3 should be colored green..

I have tried a lot of combinations and formulae and its not working... any help would be highly appreciated.

 

[6StringJazzer]

I find your description to be a little inconsistent. I am sure this is going to be straightforward once we sort out what you need.

Value in the adjacent cell in the same row should be a fixed text

Adjacent cell to the left, or to the right?
When you say "fixed text" do you really mean "Deployed"?

Value in a fixed cell anywhere in the file

No idea what you mean by this or how your example illustrates it.

If I'm looking at Cell D3, if the value is more than 0, if the value in D2 = Deployed and if the value in A3 is Deployed, then the cell D3 should be colored green..

Why are you looking to see if D2 = "Deployed"? There is no mention in any of your requirements about the cell above the cell to be formatted.
Your requirement was that "Value in the adjacent cell in the same row should be a fixed text". A3 is not adjacent to D3.

 

[dreid1011]

Perhaps this:

Book1
	A	B	C	D
1	Location	A	B	C
2		Not Deployed	Deployed	Deployed
3	Deployed	0	0	0
4		0	200	0
5		No Data	No Data	No Data
6	Deployed	0	0	200
7		0	250	0
8	Deployed	0	0	0
9		0	0	0
10		0	0	0
11	Deployed	0	30	25
12		0	0	0
13		0	0	0
14	Deployed	0	50	0
15		0	0	0
16		0	0	0
17	Deployed	0	0	10
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D17	Expression	=AND($D3>0,$D$2="Deployed",$A3="Deployed")	text	NO

 

[Cherian George]

Perhaps this:

Book1
	A	B	C	D
1	Location	A	B	C
2		Not Deployed	Deployed	Deployed
3	Deployed	0	0	0
4		0	200	0
5		No Data	No Data	No Data
6	Deployed	0	0	200
7		0	250	0
8	Deployed	0	0	0
9		0	0	0
10		0	0	0
11	Deployed	0	30	25
12		0	0	0
13		0	0	0
14	Deployed	0	50	0
15		0	0	0
16		0	0	0
17	Deployed	0	0	10
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:D17	Expression	=AND($D3>0,$D$2="Deployed",$A3="Deployed")	text	NO

yes this is what i'm looking for

 

[Cherian George]

yes this is what i'm looking for

but how do i apply this formatting?

 

[Cherian George]

but how do i apply this formatting?

got it - thanks a lot - this is what i was wanting - this fixed my issue

thanks a ton