Forum Discussion
Solved
Help with Conditional Formatting
Hi all, I'm relatively new to the more powerful uses of excel, and I'm having difficulty with some conditional formatting I was trying to do. I'm in catering, and we have a spreadsheet that track...
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)
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.