If you select your range (Just select the range you want to conditionally
format), then you can write the formula using $c and the row number for the
activecell.

Excel will adjust the formula for the other cells in that selected range.

(But copy|paste special|formats could work if there were no other formatting
that you were afraid of losing.)

Rich K. wrote:

Ok - figured out thru trial and error - had to change cell value from C2 to
$C2 and use paste special/format and that seemed to work.

Thanks anyway

"Rich K." wrote:

Dave,

Have similar situation but not sure how your solution works. Have a
spreadsheet with variable number of rows but fixed number of columns. Want
to color entire row if value in column C meets requirements. Interpreting
your select range at A1:X999, I put cursor at corner of left of column A,
above row 1 so all rows/columns are highlighted. Then went into conditional
formatting and put in formula and format color. When I hit ok, the line
above the row that should have been highlighted was highlighted and only the
first two columns were highlighted. What did I do wrong?

"Dave Peterson" wrote:

Select your range to format A1:X999 (say) (include as many columns as you want)

With A1 the activecell
format|Conditional formatting
Formula is: =left(a1,1)="-"
and give it a nice format


Nedzad wrote:

thanx for this answer,
i ask wrong question, is it posible to change row color

"Ashkan" wrote:

1- goto Format menu and select conditional Formatting
2- select Cell Value is
3- change to less than or equal to
4- 0
5- click format
6- select color
7- copy cell
8- paste special, Format

"Nedzad" wrote:

Hi

I would like to change cells color for some specific data for example i have
30000 articles an i would like to highlight those articles that have minus
sign in front of number

--

Dave Peterson


--

Dave Peterson