Forum Discussion
Conditional formatting
In your original question, you mentioned column H.
Now it turns out to be column I instead of column H.
So obviously, you should use column I in the conditional formatting formulas:
=$I1="BOILER"
etc.
Hi HansVogelaar
I have figured it out. I do need to apply it to each individual cell, however this is done by applying the formula to a single cell, then dragging it down to the rest. This doesn't do the entire column, but I am able to keep dragging it down as needed.
Thank you for your help, I hope you have a good day! 🙂
Yeah I did try that method to no avail unfortunately.
If you select columns A and I before creating the rules, as I suggested in my first reply, you don't have to fill or use the format painter. Excel will automatically adjust the rules for all cells in the selection.
