Excel - Conditional Formatting on a range IF another cell =

Copper Contributor

Hi

I want to apply conditional formatting to a range of cells IF one cell = a value.

 

Example:  =IF A1:A500 = "S"   then I wish to shade the cells of that row, A1:L500

 

I used to be able to in the old Excel!  :'(

6 Replies

Example:  =IF A1:A500 = "S"   then I wish to shade the cells of that row, A1:L500

shouldn't the A1:L500 read A1:A500?

 

pls see image:

HTH

condformat.PNG

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

 

 

pls see image & the attached file.

HTH

 

condformat.PNG

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

Lorenzo, you may use only one rule

image.png