Help-Conditional Formatting( color code) based on combination of 2 columns|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello Everyone,

I need some advice on the following questions, grateful I you can provide any tips or solutions

Following the combination below, I would like to write a rule base on the user inputs to color code red or green the field the users has entered

e.g User inputs the following in a cell Beauty_Event or Beauty_Haircare this will be ok so I want this to appear green as this is a valid combination, if the user puts Beauty_Grooming then I want the cells to be highlighted red, below are some combination that I need to check based on user inputs. The User input will be split into 2 cells to drive the make the check easier

Grateful if anyone can provide some guidance on how to go about writing an if statement or VBA to solve this problem. Thanks 🙂