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)
me too