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...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
Hi HansVogelaar
So when I type a word (such as "BOILER") into an "I" cell, I would like that cell, and the corresponding cell in the A column to turn the appropriate colour.
NOTE: I do not want the entire row to turn that colour, just the specified cell(s) in that row.
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! 🙂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.
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.
- Yes that's right, I did try that.
I understand that people may make that mistake, but I did not 🙂
