Sep 07 2018 06:08 PM
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! :'(
Sep 07 2018 06:26 PM
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
Sep 07 2018 06:42 PM
No, because I wish the result to look like this ….
Sep 07 2018 07:46 PM
pls see image & the attached file.
HTH
Sep 07 2018 07:48 PM
Sep 08 2018 05:01 AM
Lorenzo, you may use only one rule