Really depends on your condition, doesn't it?

Say the condition is that the cell in column D is "Yes"

Then, highlight the row(s) to CF and enter (assume row 1 is active)


CF1: Formula is =$D1="Yes"
Format1: <pattern/<highlight color

XL will adjust the reference for additional rows.

In article ,
Rob wrote:

How do I format a row with conditional formatting?