Condtional Formatting Multiple Rows with select Value

Question

Hi,&nbsp;&nbsp;If anyone could help that would be great.&nbsp;&nbsp;I'm trying to make a rule on multiple lines where I need cells E-J formatted depending on conditions of cell D in the rule and to then apply this rule for multiple rows using the same rule as above&nbsp;&nbsp;I have this in for one row, but when I extend the CF it keeps the cell I want to be variable D178 only&nbsp;&nbsp;

harun24hr · Answer

I assume you need to change Applies to range from $E$178:$J$178 to $E$178:$J$1000 (as per your need). Can you please share a sample file.

operations1240 · Answer

Hi Harun,Unfortunately as a new member I am unable to share a sample file.

Forum Discussion

Condtional Formatting Multiple Rows with select Value

Share

Resources