Conditional Formatting based on Checked Boxes

[Hunter Childress]

Please view the attachment. I am trying add conditional formatting in the Training Plan row based on the # of check mark selections in the Should and Actual rows.

If Should is checked but Actual is blank, then Red in the training plan box.
If Should and Actual equal each other, then Green .
If Should checked on 3 boxes but Actual is checked on 2 boxes, then Yellow.
If Should is blank, leave White.

Let me know if you have any questions

 

[Monty]

Hello Hunter

You cano add conditional formatting based on the criteria you mentioned, you can follow these steps:

1. Select the cells in the Training Plan row where you want to apply conditional formatting.

2. Go to the "Home" tab in the Excel ribbon.

3. Click on "Conditional Formatting" in the Styles group.

4. Choose "New Rule" from the drop-down menu.

5. In the New Formatting Rule dialog box, select "Use a formula to determine which cells to format".

6. For the first condition (Red if Should is checked but Actual is blank), enter the following formula:
=AND($B2="Yes", $C2="")

7. Click on the "Format" button and choose red as the fill color. Click "OK".

8. Click "OK" again to apply the rule.

9. Repeat steps 4-8 for the remaining conditions:
- Green if Should and Actual equal each other:
=AND($B2="Yes", $C2="Yes")
- Yellows if Should checked on 3 boxes but Actual is checked on 2 boxes:
=COUNTIF($B2:$D2, "Yes")=3
- White if Should is blank:
=$B2=""

After applying these conditional formatting rules, the Training Plan cells will change colors based on the criteria you specified.