Forum Discussion
Forge101
Feb 20, 2024Copper Contributor
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...
HansVogelaar
MVP
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.
Forge101
Feb 20, 2024Copper Contributor
When you say "Formulas", are you saying that I need to do that for each individual cell in the A column? Because my question is regarding the idea of lots of entries going forward, hence why I want to apply the formula to the entire column with 1 conditional format if possible.