Conditional Formating Help

[Dnyan]

Hi,

I am making one tracker and I want to make conditional formating in this sheet.

Wants to apply conditions on coloumn E & F Product and his limit.
For Exaple: if multiple value of EL is given coloumn E then conditional formating required for coloumn F i.e. if Amount is >+ 25000 then colour is red



Product

Limit >=

EL

25000

PL

25000

MD

1000000

TH

10000

MNY

10000

CAR

25000


Please give me the solution.

Regards
Dnyan188

[Bob Phillips]

Use conditional formatting with a formula of =E5>VLOOKUP(F5,$J$5:$K$10,2,FALSE)

[Dnyan]

Hi,

Thanks for help
but I think this formula for only one row i.e. E5 & F5.

I want conditional formation for column E & F

[Bob Phillips]

No, you select all of the cells that you want the CF to apply to, starting with E5, and then set the CF formula for them all in one fell swoop.

[Dnyan]

Hi,

Yes, now its working properly

Thanks you very much for help