Forum Discussion
Solved
Conditional Formatting for Multiple Cells
Hello, I am trying to create an excel spreadsheet that will accept conditional formatting but have it apply to multiple cells. Using the example below, when I enter "XYZ" in the 5th column ...
=OFFSET(A1,0,3)="ABC"You can try this and 3 additional rules for conditional formatting in the attached file.
=$A$1:$H$26This is the range the format applies to in the example.
Hmmm this is close but ever so slightly too specific for my use case.
The sheet I am using actually has multiple columns and so the goal would be to be able to insert "ABC" anywhere in the sheet and also have the preceding 3 cells change color there. Apologies for not specifying that earlier.
Is that still possible?
The sheet I am using actually has multiple columns and so the goal would be to be able to insert "ABC" anywhere in the sheet and also have the preceding 3 cells change color there. Apologies for not specifying that earlier.
Is that still possible?
=OFFSET(A1,0,3)="ABC"You can try this and 3 additional rules for conditional formatting in the attached file.
=$A$1:$H$26This is the range the format applies to in the example.
- That's the one! Now just to enter a heck of a lot of formatting rules for different letters haha. Thank you!