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.
=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!