Excel 2010 conditional formatting 1

[disturbedone]

I have a simple worksheet that I'd like to do some conditional formatting on but I can't see a way of doing it. I can do it partially but not fully.

1 ColumnA, ColumnB, ColumnC
2 1/1/11, 10001, sometext
3 2/1/11, 10001, moretext
4 2/1/11, 10002, texttext
5 3/1/11, 10001, stuff
6 3/1/11, 10003, sometext

What I'd like to do is highlight the entire row (or at least the cells in columns A-C) when the value in ColumnB = 10001. So in my example above it could fill colour cells A2/B2/C2, A3/B3/C3 and A5/B5/C5 in red. It could leave cells A4/B4/C4 and A6/B6/C6 with no fill colour.

Is this possible? I can get cells B2/B3/B5 to colour but not the corresponding cells in columns A & C.

Any ideas?

 

[SkipVought]

Hi,
[tt]
=$B1=1001
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

I should mention these vital facts that you need to know.

1) Whenever you perform a Conditional Format, begin by selecting all the cells that you want to display the desired format.

2) Realize that the CF formula you enter, will be relative to the FIRST ROW of your selection and that your CF formula will propagate to ALL cells in the selection as if you copied the formula and pasted it into the selection.

3) Many times you must use both ABSOLUTE and RELATIVE reference notation. In your case, you stated that you wanted to, "highlight the entire row...when the value in ColumnB = 10001." So each formula in the first row must refer to column B: in other words column B must be ABSOLUTE and the row reference must be RELATIVE.

Tip: In any formula editor (Excel Formula Bar or Conditional Formatting FORMULA Text Box), you can cycle thru all 4 cell reference states, using the F4 key like $A$1, A$1, $A1, A1

See Switch between relative, absolute, and mixed references in Excel HELP.
Also see Excel HELP on Conditional Formatting.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}