Color to display based on the next cel

[webmax]

Hi

i want the colour to be displayed if the region if it is equal to North.

Attaching the example for your reference.

Can u guide how to do that.

 

[Chihiro]

You had right idea. To apply to range and make reference dynamic just follow steps below.

First convert range (A4:B8) to table.
Select range you want to apply CF to (B5:B8) and use formula below.
=$A5="North"

By using table you can add new data below and it will automatically extend the table and CF along with it.