Forum Discussion
Excel - Conditional Formatting on a range IF another cell =
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...
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
No, because I wish the result to look like this ….
pls see image & the attached file.
HTH
Lorenzo, you may use only one rule
