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...
No, because I wish the result to look like this ….
pls see image & the attached file.
HTH
Lorenzo, you may use only one rule
thank you..
- change the condition / value you want in the conditional formatting..
