Integrative Modified Excel Checklist

[Zane14]

Hello, I am currently working on a project that consists of several different checklists and they need to communicate with one another. (If Sheet1 check list says <x> and another check list says <y> that the fill color of one cell would change colors to notify one person on a sheet1 that someone put <x> instead of <y>).

I started this out by using format control on each check box. Then Creating a separate sheet so that the two cells on different sheets could register that one cell is not equivalent with the other. This was a lot of work and too tedious for the amount of work I have to do.

So I dipped into VBA and learned more about BeforeDoubleClick, but only know how to change font. Is there a way to make a macro of some sort to help change the fill color of a cell on one sheet(1) and another sheet(2) IF the two do not match up.

Example of worksheet:

Sheet 1 - Mom's Grocery List

Sheet 2 - Dad's Grocery List

Mom checks off Milk and then it shows up red because Dad's checklist shows he already bought milk.
(This is just an example to help understand what I am looking for) Could anyone help me?

 

[sergioMabres]

Hi
You are close to your solution
if you know how to change the font type
instead of using .Font.Name = "Courier New"
use .Interior.Color = 255
To change background color of a cell or range to red
Cheers
Sergio