Dropdown list and condittional formatting

bionicle

Board Regular
Joined
Apr 23, 2009
Messages
168
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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

FormR

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,406
Office Version
365
Platform
Windows
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))
 

Watch MrExcel Video

Forum statistics

Threads
1,099,094
Messages
5,466,615
Members
406,493
Latest member
Hazem Hassan

This Week's Hot Topics

Top