show and tell
1 TopicConditional Formatting based on Separate Column
HI, I'm new to excel formulas and conditional formatting! I'm using a spreadsheet to track new hires, and I'm trying to figure out how I can use "less footsteps" and not have to apply conditional formatting to every.single.cell. in a column..... I'd like to be able to type in something into my "L" column, and have the "D, M, N & O" columns to change color based on what is typed. I know that I can go in and individually click on the cells and then conditionally format them, but I'm going to have well over 300 different entries that I'm going to be working with. I'd love to get that time back! I've tried searching on this forum but can't find what I'm looking for....Thanks for your help! I've attached a snip to show what I'm working with. 🙂525KViews1like3Comments