Excel Conditional formatting

Hi  Mkamala1994,

you can achieve the desired formatting based on the selected dropdown values, you can try to use conditional formatting without the need for VBA:

1. Select the range of cells or columns that you want to format.

2. Go to the "Home" tab in the Excel ribbon and click on "Conditional Formatting" in the "Styles" group.

3. Choose "New Rule" from the options.

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

5. Enter the following formula in the provided field:

    

   =$A$1="YourDropdownValue"
   
   

   Make sure to replace "YourDropdownValue" with the specific value that, when selected in your dropdown, should trigger the formatting.
   
   

6. Click on the "Format" button to define the formatting style you want to apply. In the "Format Cells" dialog box, navigate to the "Fill" tab, choose the green color you prefer, and click "OK."
   
   

7. Confirm the settings by clicking "OK" in the "New Formatting Rule" dialog box.
   
   

8. Repeat these steps for each dropdown value you want to format differently, adjusting the formula and formatting options accordingly.
   
   

   Please click Mark as Best Response & Like if my post helped you to solve your issue.
   This will help others to find the correct solution easily. It also closes the item.

   
   

   If the post was useful in other ways, please consider giving it Like.

   
   

   Kindest regards,

   
   

   Leon Pavesic