Conditional formatting, multiple cells

[oyvindn]

Hi,

I'm setting a rule in "Conditional formatting Rules Manager":

Formula: =$D3="hello"
Format: color change
Applies to: =$A$3:$J$3

I'm trying to set "Applies to": =$A3:$J3, but its just changing to =$A$3:$J$3 when I apply.

That means I cant copy/paste that cell.

I want D4 to have automatically:

Formula: =$D4="hello"
Format: color change
Applies to: =$A$4:$J$4

Can this be done?

 

[VoG]

Try selecting all of the cells that this should apply to then enter your CF formula.

 

[Andrew Poulsom]

Don't worry about the $ signs in Applies to. The row reference in the Formula will adjust relatively when the conditional formatting is copied or the Applies to range is expanded.