Conditional formatting when conditions is met

[fun2bala]

hi ,

I m trying to use conditional formatting to highlight the cells based on the data shown in right side
here need to hightlight the cell if emply and code is same then "yellow color", if not then look into which compnay belongs if same company then "peach color"
if not same company then "red color"
and same to the other company also
if same emply and code then "blue color" if not same but within that company then "light blue color" and if different company then "dark green color"

if emply, code and compnay(pepsi) then blue
and if emply, code and compnay (coco cola) then yellow
emply and code is different of same compnay then peach color
emply and code is different of different company then red color.

for coco cola (yellow, peach and red) for pepse ( blue, light blue and green)
Emply "A" code is 4210 but if it is different code then it should highlight peach subject to Same company coco cola if suppose it is pepsi comonay then it should highlight "GREEN" color

this is what I required answer This is data
DATES
Emply 1 2 3 Emply Company Code
a coco cala 4210
a 4220 4220 2220 b coco cala 4220
b 4220 4210 4210 c coco cala 4230
c 4230 4230 4230 d coco cala 4240
d 4240 4240 4240 e coco cala 4250
e 4250 4250 4220 f Pepsi 2210
f 2210 2220 4250 g Pepsi 2220
g 2220 2230 2230 h Pepsi 2230
h 2230 2240 2250 i Pepsi 2240
i 2240 2250 2210 j Pepsi 2250
j 2250 2210 2240

 

[fun2bala]

unable to discribe the data properly

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...-formatting-when-multiple-conditions-met.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.