Made a conditional format of cell B2 using a formula if B2="A" then fill the cell with colour "Green" and if B2="B" then fill the cell with colour "Yellow". Then this conditional format shall be applied to range D2:E5. please advise how to copy this conditional format / formula to D2:E5
Solved by K. C. in 24 mins