I have a set of data like below. Now I want to set conditional formatting like, If A1=AA then C,E,F column will return N/A filled with red color otherwise blank. I want to avoid formula in cell.
[pre]
[/pre]
[pre]
Code:
A...B……….C……..…D……..…E………....F
1 AA…………….N/A……………....…N/A……..N/A
2
3