Conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2333986%22%20slang%3D%22en-US%22%3EConditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2333986%22%20slang%3D%22en-US%22%3E%3CP%3Ein%20a%20row%20there%20are%204%20columns%20third%20column%20has%20no%20value%2C%20when%20applying%20conditional%20formatting%20on%20the%204th%20cell%20it%20should%20compare%20the%20value%20from%20the%20second%20cell%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2333986%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

in a row there are 4 columns third column has no value, when applying conditional formatting on the 4th cell it should compare the value from the second cell

1 Reply

@Divya_Singh 

For the rule you may use formula like =$D1=$B1 and apply the rule to entire range.