Forum Discussion
Conditional formatting in Excel
Go to Conditional Formatting in the "Home" tab. Select New Rule. Then, select "Use a formula to determine which cells to format". Once there, you should type, =A1="Yes" and then go to "Format" in the lower right corner and select which options you would like to apply when "Yes" is entered in cell A1.
Do the same procedure for "No" and use =A1="" for the option with the cell being blank.
Once you have it all, make sure to use the formula as =A1="Yes" and not =$A$1="Yes". That is, use relative references, not absolute references. Once you have it all set for one cell and you make sure it works, then go to "Format Painter" on the left side of the "Home" tab and then drag the cell to cover all weeks. That will "move" your conditional formatting to all desired cells.
Go to Conditional Formatting in the "Home" tab. Select New Rule. Then, select "Use a formula to determine which cells to format". Once there, you should type, =A1="Yes" and then go to "Format" in the lower right corner and select which options you would like to apply when "Yes" is entered in cell A1.
Do the same procedure for "No" and use =A1="" for the option with the cell being blank.
Once you have it all, make sure to use the formula as =A1="Yes" and not =$A$1="Yes". That is, use relative references, not absolute references. Once you have it all set for one cell and you make sure it works, then go to "Format Painter" on the left side of the "Home" tab and then drag the cell to cover all weeks. That will "move" your conditional formatting to all desired cells.
- Very cool, thanks! The only thing I did differently was after setting the three rules on a single cell, I went to 'Manage Rules' under Conditional Formatting (because I wanted to make sure I'd deleted my earlier failures) and saw that I could specify a range of cells, so I just edited there and it applied the rule to the entire team/season without using the format painter.
