Excel 97 conditional format

  • Thread starter Thread starter drdraxx
  • Start date Start date
D

drdraxx

I'm looking to conditionally format an entire row based on the value of
a specific cell.

Example:

yes bla 323 <-- want row yellow
no ese 352
no hjs 873
yes sie 395 <-- want row yellow
no mio 987

I want to format so that if col 1 is "yes" fill the color of the cells
in that row to yellow.

Let me know if anyone knows how to do this.
 
Select the rows you want to CF. Assuming the Active cell is A1, use

CF1: Formula is =$A1="yes"
Format1: Patterns/<yellow>
 
you need to highlight the first row containing your data, then go to
the conditional format option and chose "formula is" in the drop down.

Enter the formula

=$A3="yes"

in the box (assuming its on row 3) and press OK. You may need to go
back to check as excel often puts extra "" apostrophes in. just delete
these so the formula looks exactly like above and press OK agian -
should be fine now.

To finish it off just copy the entire row, highlight the remaining rows
you wish to format in this way, and choose paste special / formula
only.
 
Oh yeah, forgot to mention about changing the pattern to yellow in the
conditional format section, but that is the obvious part!! and JE beat
me to it anyway :)
 
Select your range of rows (ctrl-a (twice in xl2003) to select them all)

then with A1 the activecell
format|Conditional formatting
Choose formula is:
and use this formula:
=$A1="yes"

Excel will adjust the row (1) for each row in the selection, but that $ means
that it'll always look at column A.

And use a nice color on the Patterns tab under the format button.
 
Pre-select all the rows in question.

Format>CF>Formula is: =$A1="yes"

NOTE: the $ sign is a must to lock the column but not the row.

Format>Patterns>Yellow.


Gord Dibben Excel MVP
 
Back
Top