Hello Experts,
Need your help with one issue which I am trying to resolve, I have a data in which I applied the Conditional formatting based on the helper column as below -
1) If Current Coverage CN (M) = Previous Coverage CN (M) it will result N
2) If Current Coverage CN (M) > Previous Coverage CN (M) it will result T
3) If Current Coverage CN (M) < Previous Coverage CN (M) it will result F
The colours for the above conditions I have set in the conditional formatting is Red for F, Green for T and Yellow for N.
But here the strange thing is conditional formatting is working for some cells and for some cells it's not working for example -
Row no. 5 Previous Coverage CN(M) = Current Coverage CN(M) but it is showing green colour ideally it should show yellow.
Same way Row No.1 Current Coverage CC% = Previous Coverage CC% which is 29% but it is showing Green colour in Current Coverage CC % whereas below cell in the same column that is row no.2 is equal to Previous Coverage CC% that is 42% and it showing correct result as yellow.
Please refer the attachment.
The formula for helper I have used as below.
=IF([Current Coverage CN(M)]@row = [Previous Coverage CN (M)]@row, "N", IF([Current Coverage CN(M)]@row > [Previous Coverage CN (M)]@row, "T", "F")).
Can anyone suggest what is the issue here?
