Conditonal formatting
3 conditions
1. Cell value is equal to "0" then color 1
2. Formula is =countif($bn$3:$bn$27,$d3)>0 color 1
3. Formula is =countif($bn$3:$bn$27,$d3)=0 color 2
Conditonal formatting
3 conditions
1. Cell value is equal to "0" then color 1
2. Formula is =countif($bn$3:$bn$27,$d3)>0 color 1
3. Formula is =countif($bn$3:$bn$27,$d3)=0 color 2
I need your support to add reputations if my solution works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks