Forum Discussion
BETHANY LYONS
Feb 07, 2018Copper Contributor
Conditional 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 fo...
ISzegedi65
Copper Contributor
I think this is what you are looking for:
Based on a content of Column "H" the cells from "A2" to "Z1048676" filled with selected color.
If you want use only a single cell, just fix it: Instead of $H2 use $H$2 (replace with your specific cell)
DAB_SG
Feb 07, 2024Copper Contributor
How about changing the content to number?