Conditional Formatting of cell background color based on checkbox
Hi there,
I know the topic of conditional formatting was already discussed several times. However, would someone please assist me in achieving the following automatic formatting:
I have a table with several line items and a column named "Result". It contains three checkboxes in every line item as per attached picture. The background color of the cell containing the checkbox shall be set automatically. (I don't know if it creates a problem when more than one checkbox is ticked off. If several checkboxes are ticked off then this would we nonsense but technically possible. Whatever solution the macro has in this case will be fine [no color, color of last ticked, etc.] as long as the correct color is set for the single checkbox.)
1 answer
Sedera Randria
Rising Star 
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.