CODEWITHSUNDEEP
excelvba
Hannah Kirsche
Hannah Kirsche

Reputation: 1

Change the interior Colour of a specific cell range when I activate a checkbox and the value of the connected cell turns to True or "WAHR"

I have a table with repeating tasks that have to be completed for every case repeatedly. I already created a macros that automatically adds 6 rows on top of the table with the description of the individual steps that need to be done to fulfill one task and automatically inserted checkboxes for every step that are connected to the cell one step to the right next to them. U can see that in the Link.

Now I want to create another macros, where if one task gets completed (the checkbox gets activated) I want the backround of specific cells next to the cell where the value changes from True to false to get a green backround (RGB: 198,224,180). The problem is that my excel is german and automatically sets the value of the to the checkbox connected box to "WAHR" which means "TRUE" and "FALSCH" which means "False". So I dont really know how to deal with this. I already tried so many codes related to this topic and nothing works.

Here u can see the table

enter image description here

I want e.g. the cells G3:I3 to turn green (RGB: 198,224,180) if the checkbox in H3 is activated and it says "WAHR" in I3. Also the cells G4:I4 to turn green if the checkbox in H4 is activated and it says "WAHR" in I4... and so on. Ultimately if the last row is checked I also want the big now orange square in J3 to turn green as well.

Upvotes: 0

Views: 77

Answers (1)

Malte Susen
Malte Susen

Reputation: 845

You can use the Conditional Formatting function for that purpose.

Mark the cells from Column I of your sheet, then click on Home -> Conditional Formatting and select Classic as style.

In the next window, select Only format cells that contain and underneath select Specific text. In the field on the right hand side, you can then add WAHR as the trigger text and chose a formatting rule in the field at the bottom of the window. That should solve your problem.

Upvotes: 1

Related Questions