Dropdown list and condittional formatting

[bionicle]

hi all,

quick question, is there a way to have different conditional formatting based on the dropdown list?

for instance, if I had a dropdown saying "temperature inside" can I have a conditional formatting that would give me a between 21 and 30 and if I changed the dropdown to say temperature outside it would change to conditional formatting on the same row to a new between range.

if this is possible what would that look like as I've tried to use the use a formula to determine which cells to format but cant get anything to work.

thanks in advance

Steve

 

[FormR]

Hi, if A1 was your dropdown and B1 was the cell you wanted to format, one option could look like, for example:

=OR(AND($A$1="Temperature inside",B1>=21,B1<=30),AND($A$1="Temperature outside",B1>=10,B1<=20))