Forum Discussion
Conditional formatting
I want to be able to change the fill of a cell based on the text placed in another cell. Example: If I type "BOILER" into a cell in column H (eg H41) then I want the corresponding cell in another...
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.
Yes that's right, I did try that.
I understand that people may make that mistake, but I did not 🙂
I understand that people may make that mistake, but I did not 🙂
