How to create conditional formatting based on other conditional formatting?

[skhandelwal]

So I need a create a conditional formatting to color this cell blue if conditional formatting on other cells are painted blue and more complicated versions of this. Thanks!

 

[Toadstool]

AND with the other CF formula.

 

[skhandelwal]

I'm not trying to use them together. Conditional formatting is already done on row. I'm trying to highlight 1 cell if if conditional formatting is met on 3 others. Or if its not met on 1 of them, if it is met on another to compensate for it.

 

[Joe4]

Conditional formatting runs off of values, not cell formatting.
So if you wanted to run Conditional Formatting off of Conditional Formatting, you would have to do so indirectly by running it off of the same rules as the first Conditional Formatting (so you would combine both sets of rules together).

For example, let's say that you have conditional formatting on cells A1, B1, and C1 that makes it blue if the value is greater than 0.
If you then wanted to conditionally format cell D1 if all three cells (A1, B1, and C1) are formatted blue, you would do so NOT by looking at their color, but the rule behind the color.
So you would use the conditional fomatting rule on D1 of:

=AND(A1>0,B1>0,C1>0)

(all three other rules combined together in one "AND" statement, just like Toadstool said).

 

[Toadstool]

Hi skhandelwal,

@Joe4 just said it, but I was working on an example so here it is. If the other Conditional Formats are using formulae then you can just use the same formulae with an AND statement.

Here block one highlights amber if it is a value less than the cell below.
Block two highlights if its contents are different to the cell below.
Block three highlights if the same position in blocks one and two are highlighted and the contents of this cell are "Y".

skhandelwal.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1		Block 1				Block 2				Block 3
2	22	23	1		Y	Y	N		Y	Y	N
3	25	1	27		Y	Y	Y		Y	Y	Y
4	16	2	3		N	N	N		N	N	N
5	19	20	21		Y	Y	Y		Y	Y	Y
6	2	14	15		Y	N	Y		Y	N	Y
7	3	17	18		N	Y	Y		N	Y	Y
8	1	20	2		N	N	N		N	N	N
9	1	2	3		Y	N	N		Y	N	N
10
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I2:K9	Expression	=AND(I2="Y",A2<A3,E2<>E3)	text	NO
E2:G9	Expression	=E2<>E3	text	NO
A2:C9	Expression	=A2<A3	text	NO