Excel - Conditional Formatting on a range IF another cell =

Question

HiI want to apply conditional formatting to a range of cells IF one cell = a value.&nbsp;Example:&nbsp; =IF A1:A500 = "S" &nbsp; then I wish to shade the cells of that row, A1:L500&nbsp;I used to be able to in the old Excel!&nbsp; :'(

lorenzo kim · Answer

Example:&nbsp; =IF A1:A500 = "S" &nbsp; then I wish to shade the cells of that row, A1:L500shouldn't the A1:L500 read A1:A500?&nbsp;pls see image:HTH

null null · Answer

No, because I wish the result to look like this ….&nbsp;&nbsp;&nbsp;

lorenzo kim · Answer

pls see image &amp; the attached file.HTH&nbsp;

lorenzo kim · Answer

change the condition / value you want in the conditional formatting..

sergeibaklan · Answer

Lorenzo, you may use only one rule

Forum Discussion

Excel - Conditional Formatting on a range IF another cell =

Share

Resources