Avatar of Patricia Timm
Patricia Timm
Flag for United States of America

asked on 

matching a string on a row in a column and coloring the cells if a match occurs

I would like to check a column called Part Rcvd if the row in the column matches Rcvd (this will be an exact match as I hope it will be hard coded in by the end user) then color the matching cell and adjacent cells in column N and column O to grey.
As an example
column N                       column O                         column P
12/3/2019                       12/10/2019                       Rcvd
Finds match in column P for string Rcvd then greys out column N, column O, and column P . Loops thru for each row within that column until it reaches the end. Thanks in advance. Would it be better to code this in VB or use a formula manager in excel to create? Not sure which is more efficent. There currently are no formulas or vb code running on this sheet. More informational so process time is short
VB ScriptMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon