Create a flag and color cell accordingly

[BhaminiParmar12]

The below is my data in this I want to create a flag 

Num	Name	PRAG	CRAG	Value
1	ksfhwef	G	R	183
2	weifjo	R	A	600
3	weoifkwenm	R	G	174
4	wef	A	G	477
5	pocijepw	G	R	106
6	okjprrg	G	R	189
7	eproijgp	R	A	410
8	erpioj	R	G	546
9	wepoj	A	G	315
10	we	G	G	420
11	dmk2f	R	R	686
12	fvdkjvpeioj	R	G	684
13	jkbxc u	A	G	444
14	dfivjeproj	R	R	537
15	lkdmvor	R	R	143
16	rewgre	R	G	271
17	epirjf	G	G	385
18	erge	G	R	685
19	lkndvoi	R	R	431
20	mvb	R	G	426
21	vlkernlk	R	R	682
22	ervmer	A	R	454
23	qefmkpap	G	A	271
24	kjsendwqed	G	G	624
25	ekwmdoi	R	G	614

I need to create a flag 

CRAG	Direction
R	Neutral
G	Up
A	Up
G	Up
R	Down
A	Neutral
A	Down
R	Down
G	Neutral

I want the output like this 

[BhaminiParmar12]

Thanks, @Rohan I will Try and Let You Know.

[BhaminiParmar12]

Hi @Rohan I tried this but the output is not coming as Per My Requirement
As You see the First one A,G Is Up But It came Down
same for all 

[Rohan]

Hi @BhaminiParmar12 ,

My bad, i missed the order in the applymap : 

Applymap('DirectionMap',PRAG&'|'&CRAG,'N/A') as Direction

Let me know if this works.

Regards,

Rohan.