Highlight a row using conditionalcformatting

[abc]

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

 

[Per Jessen]

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.

 

[daniel]

yes-select the range and enter the formula