CODEWITHSUNDEEP
excel
User123456789
User123456789

Reputation: 149

Conditional formatting based on data in another sheet Excel

I try to conditional format the table to the right (table2) based on the table to the left (table1) (and the tables are in different sheets):

enter image description here

All cells corresponding to a cell in table1 with a value different from 0, must be colored in table2, like illustrated below:

enter image description here

How can I do this?

Upvotes: 1

Views: 1111

Answers (1)

basic
basic

Reputation: 11968

If you want format only corresponding cell just use formula in CF:

=Sheet1!B1=1

enter image description here

if you want find proper name then use:

=SUM(($A1=Sheet1!$A$1:$A$8)*(1=Sheet1!B$1:B$8))

enter image description here

Upvotes: 1

Related Questions