Hi All,

is there a way to highlight a whole row in a certain color (instead of a
single cell) by using conditional formatting?

As far as I can see it only works on cell-by-cell basis?

Thanks

Hi

To highlight row1 if A1="Apply Formatting", select the entire row and goto
conditional formatting.
Condition1: Formula is Enter this formula. =$A$1="Apply Formatting"

Format as desired.
Remember to use absolute cell references in the formula.

Hopes this helps.

---
Per

"abc" skrev i meddelelsen
...
Hi All,

is there a way to highlight a whole row in a certain color (instead of a
single cell) by using conditional formatting?

As far as I can see it only works on cell-by-cell basis?

Thanks

yes-select the range and enter the formula

"abc" wrote:

Hi All,

is there a way to highlight a whole row in a certain color (instead of a
single cell) by using conditional formatting?

As far as I can see it only works on cell-by-cell basis?

Thanks