highlight range if cell contains desired data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If any cell in column D:D contains desired data in string format ( i.e.
"Bill G" ), how would I highlight the data range in that respective row?

Example:

cell d4 contains the text "Bill G". Excel automatically colors the range
4a:4i in red.
 
1. Select columns A to I.
2. Go to Format > Conditional Formatting
3. Select "Formula Is" on the drop-down arrow, and put:
=$D1="Bill G"
4. Press the Format radio button and format as desired.

HTH
Jason
Atlanta, GA
 
Select cols A to I

Click Formatting > Conditional Formatting
For condition1, set it as:
Formula is | =$D1="Bill G"
Click Format button > Patterns > Red? > OK
Click OK at the main dialog
 
I guess I wasnt specific enough. Lets imagine pasting data that is 10 columns
wide by 1200 rows long. After I paste this data, the respective rows would
automatically color themselves according to what was in column "D" of the
respective row. So what I need is instruction on creating a formula for the
whole worksheet. I do not wish to select a row and then conditionally format
it. I want the software to perform it for me.
 
I guess I wasnt specific enough. Lets imagine pasting data that is 10
columns wide by 1200 rows long. After I paste this data, the respective rows
would automatically color themselves according to what was in column "D" of
the respective row. So what I need is instruction on creating a formula for
the whole worksheet. I do not wish to select a row and then conditionally
format it. I want the software to perform it for me.
 
TOB

Select Column A through I(or a range of cells in Columns A to I) then
Format>Conditional Formatting and Formula is:

=$D1="Bill G." note the $ sign to lock the column but not the row.

Pick a color from Format>Pattern and OK your way out.


Gord Dibben Excel MVP

On Wed, 23 Mar 2005 13:51:06 -0800, "The Other Bollinger" <The Other
 
... I do not wish to select a row and
then conditionally format it ...
Click to expand...

If you re-read the response given, the 1st step was to select the entire
cols A to I, not row by row. And the cond format formula will self-adjust
relatively to fit what is required per row. Try it again, and then test it
out to convince yourself. Input "Bill G" at any cell within col D, say in
D10. You'll see that the range A10:I10 will be formatted with red fill.
 
TOB

I think you missed the part in all three posts that specified

"select columns A to I" which means select the entire columns by clicking on
the column headers.

If you want more columns, select them before doing the CF steps.

If you want all columns, hit CTRL + A(twice in 2003)

Try it, you'll like it.


Gord

On Wed, 23 Mar 2005 15:11:02 -0800, "The Other Bollinger" <The Other
 
Back
Top