Using conditional formatting on a drop down list

**scottatbuckman** · 02-13-2014, 10:37 AM

I have a drop down list that when an item in the list is selected I need to use conditional formatting on. I am looking at a cell on another sheet for one of the conditions.
I tried this

=($H3="BATCH")*(PV!$C1="1")

H3 is on the current sheet, and BATCH is the item in the dropdown list that Im wanting to format. PV is the name of the other sheet im wanting to pull cell C1 info from.

I saw somewhere that the * worked for someone... Anyhow, when I apply it, it does turn my cell the right color, but when the dropdown box is moved to something else, then comes
back to the one that should be colored, it no longer works, and my formula is changed...im guessing because of the *, doing multiplication or something, lol. Can anyone help me?

**TMS** · 02-13-2014, 11:25 AM

Suggest you post a sample workbook.

Regards, TMS

**hemesh** · 02-13-2014, 11:31 AM

You could do one thing create a named range as pointer with relative referencing =PV!$C1
in data validation if you want one of the condition true then apply formula as
=Or(($H3="BATCH"),(pointer="1"))

if you wan both of the conditions to become true then
=And(($H3="BATCH"),(pointer="1")) used in the sheet

check -- formula and name manager and check pointer