Changing cell colors

Question

I have two sheets in the same workbook, I want to change the cell color of all cells in the second sheet that contain value from the first sheet.Egsheet A values&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sheet B valuesDoor&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; chaircar&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; carman&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; manwomanso cells in B that contain data from A will be painted blue

peterbartholomew1 · Accepted Answer

Jerry_john&nbsp;COUNTIFS returns 0 (FALSE) if the cell value is not found in listA.&nbsp; The rule is fired if the cell content is present in listA.

Forum Discussion

Changing cell colors

Share

Resources