Greetings,
I want to update the conditional formatting in my SS by adding an alternative cell value to an existing condition - e.g that if the input is either “1” OR “2” then the output is the same.
In the present case I have:
Condition 1
Formula is $D3=“IND” ( which determines that the output number is fixed to two decimal places)
I had thought that as I want the same condition to be applied to a different value in the same cell then I could use the “OR” operator in a formula rather than add a new condition. I have tried varying combinations and placement of “OR” but this doesn’t work and instead messes up the formatting for the first value “IND”. As I have a fair number of similar additions I would like to avoid having to duplicate all the conditions but it’s not a major pain if it’s not feasable.
Any help would be much appreciated