Conditional Formating with reference to another cell

**Spencinator** · 09-25-2008, 05:34 AM

Hello

I need to colour the Cell A1, A2 and so on in reference to the Cell Value in Cell B1, B2 and so on.

For example if i have the word "urgent" in cell B1, the cell A1 has to get a red colour. If i have the word "uninteressting" in cell B2, the cell A2 has to get a green colour.

How can i get this? Do I need to use a makro or is it possible with a conditional formating with reference to another cell?

Greets

**dominicb** · 09-25-2008, 05:43 AM

Good morning Spencinator

Yes this is quite possible, and really easy.
Go to cell B1 and go to Format > Conditional Format and select Formula Is from the dropdown box, then copy this formula below and Ctrl + v to paste it into the text box :
=$A$1="Urgent"
Choose your format and click OK.

HTH

DominicB