Change row fill color depending on cell value

[Nick70]

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.

 

[Joe4]

Use Conditional Formatting formulas.

First, select the range A2:Z100.
Then go to Conditional Formatting and choose the formula option, and enter the formula:

=$B2="pear"

and choose yellow fill color formatting option.

Repeat the process, setting up a second rule for the "apple" option.

 

[Nick70]

great thanks!
N.

 

[Joe4]

You are welcome!
Glad I was able to help.

 

[Nick70]

Hi Joe4,

Quick question.
Because I need to apply this conditional formatting to a new sheet every day is there a way to insert this conditional formatting using a macro?
So can we use a code that inserts conditional formatting =$B2="pear" for a specific range?

Could I for example record a macro as I apply this conditional formatting and then save it?

Thanks,

 

[Nick70]

In fact I recorded conditional formatting and saved as macro and works fine!