Hello everyone,
I'm not sure if this is how I would go about this (using an if statement or what) but I can't figure out a way to make it so a cell will auto-fill with a certain color based on information in a different cell.
I have information in column B - either "New Group" or "Renewal"
I want column F to auto-fill to black if column B is a "Renewal"
I'm new to excel and I've been googling and I can't seem to figure out if this is even possible?
Thanks so much!
I'm not sure if this is how I would go about this (using an if statement or what) but I can't figure out a way to make it so a cell will auto-fill with a certain color based on information in a different cell.
I have information in column B - either "New Group" or "Renewal"
I want column F to auto-fill to black if column B is a "Renewal"
I'm new to excel and I've been googling and I can't seem to figure out if this is even possible?
Thanks so much!
