Forum Discussion
Help with Conditional Formatting
This is what the rule looks like:
The 'Applies to' range starts in row 1, but the formula refers to cell I2. It should refer to the first row of the range, so it should be
=$I1="Peyton"
You can change this by selecting Conditional Formatting > Manage Rules... on the Home tab of the ribbon, then clicking Edit Rule...
OK your way out when done.
The rule then works as intended:
(I removed all manually applied fill coloring to better demonstrate the result)
If you could upload or attach a copy of the workbook, that would be helpful.
HansVogelaar here is the link to the Sheets copy--new to the site and figuring out how to attach the excel file
https://docs.google.com/spreadsheets/d/1dySeuuAsYYQatDJOcU61IHkjaYgzh7dQfVRNvh2jTPM/edit?usp=sharing
This is what the rule looks like:
The 'Applies to' range starts in row 1, but the formula refers to cell I2. It should refer to the first row of the range, so it should be
=$I1="Peyton"
You can change this by selecting Conditional Formatting > Manage Rules... on the Home tab of the ribbon, then clicking Edit Rule...
OK your way out when done.
The rule then works as intended:
(I removed all manually applied fill coloring to better demonstrate the result)
- Hans, thank you so, so much--so the problem was as simple as failing to match the formula to the designated range? That's very good to remember. I greatly appreciate your help.
Yes, that was the problem.
I have downloaded the file from Google Docs as an Excel workbook