Hi,
I have some data in range (A2:Z100) in Sheet1.
I would like rows to have yellow fill color if cell in column B contains text "pear".
I would like rows to have green fill color if cell in column B contains text "apple".
It is not entire row that must change fill only between column A and Z.
So if cell B5 contains text "pear" then Range(A5:Z5) will change color.
How do I do that?
Thanks,
N.
I have some data in range (A2:Z100) in Sheet1.
I would like rows to have yellow fill color if cell in column B contains text "pear".
I would like rows to have green fill color if cell in column B contains text "apple".
It is not entire row that must change fill only between column A and Z.
So if cell B5 contains text "pear" then Range(A5:Z5) will change color.
How do I do that?
Thanks,
N.