Newb question in excel use

[serimral]

I have a number of columns with data in a spreadsheet.
I would like the background colour in individual cells in one column to change colour if a particular word is written within individual cells in another column.
Is this possible?
Can an esteemed Excel user point me in the right direction?
I am using 2007

Thanks

 

[VoG]

Take a look at Conditional Formatting on the Home tab.

 

[wigi]

Hello, welcome to MrExcel.

You need conditional formatting. If you search in the forum, you will find plenty of topics. Also on the world wide web, a lot of website will explain it in an understandable way.

 

[serimral]

Thanks for the replies.
I have looked at conditional formatting and can set conditions for the column I am working in but I cannot see how to change background colours in different columns.
One column has cells containing numbers and the other column has cells containing text.
If a particular word is written in a text column cell, I would like the number cell to change background colour. The number will remain the same.
I can see how to set conditional formatting if I change the text/number in a particular cell in a column but not two seperate columns.

I assume I may have to delve into VB?

 

[VoG]

Select the range of numbers and use a CF formula like that shown below

Excel Workbook
	A	B
1	10	a
2	5	c
3	3	d
4	6	b
5	4	d
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =B1="d"	Abc