Need help with Conditional Formating

[Axel Van Kampen]

I have a cell with a formula that references two other cells
(=LOOKUP(CONCATENATE(D6,E6),$V$1:$W$9)).

If the two cells, D6 and E6 both contains the value of "H", then I want to
format F6 to be Bold and Red.

I have tried this: Cell Value is Equal to =AND(D6="H",E6="H") but it is not
working.

I have also tried: Formula Is =AND(D6="H",E6="H"), still no go.


Can anyone help, point me in the right direction?

 

[Dave Peterson]

Your "formula is" version worked for me.

Are you sure you set the format?

 

[Ron Rosenfeld]

I have also tried: Formula Is =AND(D6="H",E6="H"), still no go.

This formula seems to work fine for me.

Did you select F6 to conditionally format?

Try just typing an H in D6 and E6. If that works, than your original entry is
not exactly equal to "H". Maybe a non-printing character?


--ron

 

[Ron Rosenfeld]

I have a cell with a formula that references two other cells
(=LOOKUP(CONCATENATE(D6,E6),$V$1:$W$9)).

If the two cells, D6 and E6 both contains the value of "H", then I want to
format F6 to be Bold and Red.

I have tried this: Cell Value is Equal to =AND(D6="H",E6="H") but it is not
working.

I have also tried: Formula Is =AND(D6="H",E6="H"), still no go.


Can anyone help, point me in the right direction?

Another thought. If the cells can contain stuff in Addition to the "H"; in
other words, if you want RED BOLD for D6: Hotel E6: iHop then use this
formula for the conditional format: =NOT(ISERROR(FIND("H",D6)+FIND("H",E6)))


--ron

 

[Axel Van Kampen]

Your "formula is" version worked for me.

Are you sure you set the format?

You are all correct. The formula itself works. But I just realised that to
complicate this, the value "H" is entered in to D5 and E5 by a drop down
list using Validation references. And for some reason that does not work.
Even if I enter the value "H" manually in those cells, it still does not
work.

Is there a way to solve this?

Thanks all, for all your help.

 

[Biff]

Axel,

It doesn't make any difference if the values are from a
dropdown list.

Are you sure you have the cell references correct? In the
original post you mention D6 and E6, but in this post you
now say it's D5 and E5 ????

Biff

 

[Dave Peterson]

D5/E5 or D6/E6????

I understand that there is a problem with events firing in xl97 when the cell is
changed via data|validation (and the list is not typed into the Data|validation
dialog box directly).

If you're using xl97 and your list is a range on a worksheet, I'd try typing
that list into the data|validation dialog.

(I don't have xl97 anymore to test.)

 

[Axel VK]

Axel,

It doesn't make any difference if the values are from a
dropdown list.

Are you sure you have the cell references correct? In the
original post you mention D6 and E6, but in this post you
now say it's D5 and E5 ????

Yes I know. D6 and E6 are the correct ones. Still doesn't work with those
cells and values though..........

 

[Axel VK]

D5/E5 or D6/E6????

Sorry, D6 and E6 are the correct ones.

I understand that there is a problem with events firing in xl97 when the cell is
changed via data|validation (and the list is not typed into the Data|validation
dialog box directly).

If you're using xl97 and your list is a range on a worksheet, I'd try typing
that list into the data|validation dialog.

Hmm. Using 2000 so that should not be the problem.

 

[Dave Peterson]

I just tried it on xl2k (SP3). It worked ok if I built my data validation list
in the dialog or pointed to another range.

I think I'd check the formula again (and in the "Formula is" box). (maybe a
typo???)

 

[Axel VK]

I just tried it on xl2k (SP3). It worked ok if I built my data validation list
in the dialog or pointed to another range.

I think I'd check the formula again (and in the "Formula is" box). (maybe a
typo???)

Thanks mate. I think I just need to double check my own work.

Appreciate it.