Conditional formatting query

F

Fiona O'Grady

Hi,

I thought I knew how to do this, but it turns out I don't.

If I have names in column A (eg Alan, Bob, Cathy), and values in column B
(see below), is there any way I can use conditional formatting to change a
cell in A, based on a value in B?

A B
1 Alan 4
2 Bob 1
3 Cathy 3

Essentially what I'd like is to highlight the name, if the value is 3 or
over.

I know how to change the cells in B using conditional formatting, but can't
figure out how to change A cells.

Thanks,
Fiona
 
T

tjtjjtjt

Select all the cells you want Conditionally formatted.
Try this with Formula Is selected in teh Conditional Formatting Dialog:
=B1>=3
This example has Alan in A1.

tj
 
D

David McRitchie

Hi Fiona,
The cells that get colored are based on your selection as stated.
Select Column A
The formula is based on your **active cell**.
Your active cell would be A1 is you are looking at the top of the
worksheet. So A1 being the active cell would
have the formula that you enter as provided in your last reply. =$B1>=3
Actually by using $B instead of B you could select column A&B
if you want both columns to be colored, or if you want the entire row colored
you would have selected all of the cells (Ctrl+A, except in Excel 2003)

That means that A2 would be working with a C.F of =$B2>=3
etc. on down.

see Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
 
Top