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
Please give me the solution.
Regards
DnyanView attachment claims.xls
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
DnyanView attachment claims.xls