Highlight a row automatically if a cell meets certain criteria

[simonvrowley]

I would like to know how to automatically highlight a row if one of the cells
in the row meets certain criteria. I have managed to highlight the cell with
conditional formatting but would like to be able to highlight the entire row.

[Ardus Petus]

Apply conditional Formatting to all cells of the row, with a formula like
=C10="testvalue"

HTH
--
AP

"simonvrowley" <[email protected]> a écrit dans le
message de news:[email protected]...
> I would like to know how to automatically highlight a row if one of the
cells
> in the row meets certain criteria. I have managed to highlight the cell
with
> conditional formatting but would like to be able to highlight the entire
row.

[Stefi]

Hi Simon,

Select the rows you want conditional formatting to apply to, then in
conditional formatting enter this formula (suppose the condition is: cell
value in column A = "condvalue"):

=INDIRECT("A"&ROW())="condvalue"

and choose a format!

Replace ="condvalue" to your real condition, or post it to compose the
formula!

Regards,
Stefi


„simonvrowleyâ€� ezt Ã*rta:

> I would like to know how to automatically highlight a row if one of the cells
> in the row meets certain criteria. I have managed to highlight the cell with
> conditional formatting but would like to be able to highlight the entire row.

[Ardus Petus]

Sorry: my solution did not answer the question!

--
AP

"simonvrowley" <[email protected]> a écrit dans le
message de news:[email protected]...
> I would like to know how to automatically highlight a row if one of the
cells
> in the row meets certain criteria. I have managed to highlight the cell
with
> conditional formatting but would like to be able to highlight the entire
row.

[Edmund]

Hi,

When u apply Conditional Formatting to a single cell, this means only that
single cell will be formatted when criteria returns the answer as TRUE.

Try applying your Conditional Formatting to all the other cells in the range
as well. Don't forget to lock the reference cell by preceeding the cell
address (ie. column or row) with the $ sign (example $A1 will ensure all the
cells in the same row will refer to column A).

Sample:
1 .Open a new blank sheet & select range A1:D10
2. Conditional Formatting : Formula is =$A1="OK"
3. Then type "OK" in any cell betwen A1:A10
You should be able to see the effect of your conditional formatting whenever
Ok is entered into any cell in A1:A10

Hope this helps.

--
Edmund
(Using Excel XP)


"simonvrowley" wrote:

> I would like to know how to automatically highlight a row if one of the cells
> in the row meets certain criteria. I have managed to highlight the cell with
> conditional formatting but would like to be able to highlight the entire row.

[[email protected]]

Apply the conditional formatting to all the cells in the row