hi all i need help with a conditional formula.
I want for a example =$C$10:$AG$106="nbt/l"=+"nbt/l/m" to change to a specific color if either of the options are used in the drop down selection.
Now currently i only have =$C$10:$AG$106="nbt/l" which turn the cell purple but i want to use multiple arguments what am i doing wrong? thanks
I want for a example =$C$10:$AG$106="nbt/l"=+"nbt/l/m" to change to a specific color if either of the options are used in the drop down selection.
Now currently i only have =$C$10:$AG$106="nbt/l" which turn the cell purple but i want to use multiple arguments what am i doing wrong? thanks