Forum Discussion
Solved
Conditional Formatting
Hi everyone, I just need help with the “Conditional Formatting” formula. I just want column-D through column-G to be searched by the “Searching List” and highlighted that row upon matching. I almos...
Maybe with this rule for conditional formatting if i correctly understand what you want to do.
=OR(AND($D4=$D$1,$D4=$I$4),AND($E4=$E$1,$E4=$I$4),AND($F4=$F$1,$F4=$I$4),AND($G4=$G$1,$G4=$I$4))
Maybe with this rule for conditional formatting if i correctly understand what you want to do.
=OR(AND($D4=$D$1,$D4=$I$4),AND($E4=$E$1,$E4=$I$4),AND($F4=$F$1,$F4=$I$4),AND($G4=$G$1,$G4=$I$4))
Quadruple_Pawn, thank you so much for the prompt response. Your perfect formula works great. Thanks for having me download it. I appreciate it very much. Thanks a lot! May the power be with you.