Hi,
Please I would like to add a new conditional format with a custom formula.
I choose "use a formula to determine which cells to format" to insert the formula.
I've 30 values separated into 2 sets, each set is 15.
(S1-01, S1-02 ..., S1-15)
(S2-01, S2-02 ..., S2-15)
I add a drop down list contains the 30 values.
I want to add a formula in conditional format ... I want it to do the following:-
If I choose any value of the 1st set (S1-01, S1-02 ..., S1-15), I want cell color to be filled with green color and font color white.
If I choose any value of the 2nd set (S2-01, S2-02 ..., S2-15), I want cell color to be filled with blue color and font color white.
So please what is the right formula?