Column Comparision

[dayaptl]

Hi,

I need help for my daily job.
My need is
First compare cell of column E with column A and check for corresponding value in column D.

In attached sheet, cell E1= cell A39 and corresponding value at D39 is 1 then enter text of E1 with red color in cell H1. if its value is zero then with green color in cell H1. Cell E2= cell A46 and corresponding value at D46 is zero then text of E2 is of green color in cell H2.

Regards

[Bryan Hessey]

Hi,

I need help for my daily job.
My need is
First compare cell of column E with column A and check for corresponding value in column D.

In attached sheet, cell E1= cell A39 and corresponding value at D39 is 1 then enter text of E1 with red color in cell H1. if its value is zero then with green color in cell H1. Cell E2= cell A46 and corresponding value at D46 is zero then text of E2 is of green color in cell H2.

Regards

Hi,

In H1 put

=IF(VLOOKUP(E1,A:D,2,FALSE)=1,E1,IF(VLOOKUP(E1,A:D,2,FALSE)=0,E1,""))

and formula fill down, then highlight column H and Format, Conditional Format,
Formula =VLOOKUP(E1,A:B,2,FALSE)=1 colour=Red
add another
Formula =H1=E1 colour=Green - amended from this
Formula =AND(H1=E1,H1<>"") colour=Green

hth
---

[dayaptl]

Hi,

Thanks for help.

It works O.K.

Regards

[Bryan Hessey]

Hi,

Thanks for help.

It works O.K.

Regards

Good to see it work for you, and thanks for the response.

---