Forum Discussion
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 almost did it by applying this formula “=$D4=$I$4” but obviously it highlight’s the row when only column-D matches and I’m unable to include the rest of the columns (column-E through G) to be searched. I also used this formula which can look into column-D through G for search but only highlight the matching cell not the row "=AND($I$4<>"",ISNUMBER(SEARCH($I$4,D1,1)))"
Any help in this regard will be greatly appreciated and thank you in advance.
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))
2 Replies
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.
