change row color based on value in cell

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

Guest

Hi,

I am trying to do conditional formatting for an entire row, based on a value in a cell in that row. Basically, the fourth column in the row is a particular value, then the entire row should be highlighted. Can some one please give me suggestions.

Thank you.
 
Hi

Select the row. Then Format / Conditional Format. Use the Cell is
Formula option, and in the formula box type your formula relating to the
fourth cell (ie if it's row 5 you're on, base your formula on D5). For
example use:
=D5>10
and then set your format.

This will base the whole row's formatting on the one cell's value.

Andy.

haiiyaa said:
Hi,

I am trying to do conditional formatting for an entire row, based on a
Click to expand...
value in a cell in that row. Basically, the fourth column in the row is a
particular value, then the entire row should be highlighted. Can some one
please give me suggestions.
 
Hi
try the following:
- select the entire row 8lets say row 1)
- goto 'Format - conditional Format'
- enter the formula
=$D1 = specific_value
- choose your format
 
thank you all

but what if i want to apply this logic for the entire worksheet. i.e. if for any row, if the 4th cell is "-1" then paint entire row green.

how can i do that?
 
Hi
- just select all rows for which this format should apply (lets say you
start in row 1
- enter the formula
=$D1=-1
-choose your format
 
Rephrased a little bit, your formula is based on
the active cell, and the cells to be colored is based on your
selection. Every cell in the selection effectively gets it's own
conditional format (and each cell uses up one of it's 3 allowed)
and that is why the $ sign goes in front of the column because
all columns will be checked on that one column..

uses up. More information in
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Like regular number formatting, conditional formatting can be
copied as is copy and paste, use of fill handle, etc.--
 
Back
Top