Integrative Modified Excel Checklist

Zane14

New Member
Joined
Jan 10, 2017
Messages
1
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?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

sergioMabres

Well-known Member
Joined
Feb 24, 2013
Messages
946
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,924
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top