mere pass theek kam kar raha ha. Aap is conditional formatting ko srif Column A par apply krain. dosry column p apply kraingy tu dono ko highight kary ga.
Conditional formatting sa pahly apny column A ko select krain, usky bad conditional formatting m jar kar rule apply krain.

Hope this will help