"OR" in conditional formatting formula
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
Without mentioning what you tried nobody could tell where you failed, but
OR($D3="IND";$D3="<someothervalue>")
should do the job.
You are of course right.
I have tried what I understand to be the principal possibilites starting with the one you mention - which I believed should work but doesn't. The other two were out of desperation :-)
I have tested my proposal before posting (and of course it worked for me). So now it is time to upload an anonymized sample file, to find out why it doesn't work for you.
Please attach a sample file editing your question.