Conditional formatting

[Erantes]

Hi how do you mirror colour change on two different sheets in the same workbook.
Eg Sheet 1 cell A1 changes colour from say black to orange depending on certain rules i have created.
How would i get say Sheet 2 cell A1 to mirror this and also change from black to orange at same time. Thanks in advance.

 

[DanteAmor]

You must create 4 conditional formatting rules:
On sheet1:
- 1 ruler for black
- 1 ruler for orange.
On sheet2:
- 1 ruler for black
- 1 ruler for orange.

For example:
Sheet1

DANTE AMOR
	A	B
1
2
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=$A$1<>"Hello"	text	NO
A1	Expression	=$A$1="Hello"	text	NO

Sheet2

DANTE AMOR
	A	B
1
2
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=Sheet1!$A$1<>"Hello"	text	NO
A1	Expression	=Sheet1!$A$1="Hello"	text	NO

Note: Adjust the rules and colors to your needs.

 

[Erantes]

You must create 4 conditional formatting rules:
On sheet1:
- 1 ruler for black
- 1 ruler for orange.
On sheet2:
- 1 ruler for black
- 1 ruler for orange.

For example:
Sheet1

DANTE AMOR
	A	B
1
2
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=$A$1<>"Hello"	text	NO
A1	Expression	=$A$1="Hello"	text	NO

Sheet2

DANTE AMOR
	A	B
1
2
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=Sheet1!$A$1<>"Hello"	text	NO
A1	Expression	=Sheet1!$A$1="Hello"	text	NO

Note: Adjust the rules and colors to your needs.

Thanks Dante

You must create 4 conditional formatting rules:
On sheet1:
- 1 ruler for black
- 1 ruler for orange.
On sheet2:
- 1 ruler for black
- 1 ruler for orange.

For example:
Sheet1

DANTE AMOR
	A	B
1
2
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=$A$1<>"Hello"	text	NO
A1	Expression	=$A$1="Hello"	text	NO

Sheet2

DANTE AMOR
	A	B
1
2
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=Sheet1!$A$1<>"Hello"	text	NO
A1	Expression	=Sheet1!$A$1="Hello"	text	NO

Note: Adjust the rules and colors to your needs.

 

[Erantes]

You must create 4 conditional formatting rules:
On sheet1:
- 1 ruler for black
- 1 ruler for orange.
On sheet2:
- 1 ruler for black
- 1 ruler for orange.

For example:
Sheet1

DANTE AMOR
	A	B
1
2
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=$A$1<>"Hello"	text	NO
A1	Expression	=$A$1="Hello"	text	NO

Sheet2

DANTE AMOR
	A	B
1
2
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=Sheet1!$A$1<>"Hello"	text	NO
A1	Expression	=Sheet1!$A$1="Hello"	text	NO

Note: Adjust the rules and colors to your needs.

Thanks Danteamor so how would the formula be written in sheet 2 thanks.

 

[DanteAmor]

Thanks Danteamor so how would the formula be written in sheet 2 thanks.

The example on sheet 2 shows how you should write the formulas:

 

[Erantes]

The example on sheet 2 shows how you should write the formulas:
View attachment 122195

Ah i see i will try this later thanks so much for your time.