Fill with Black if another cell has value of Y

[njsdca]

Hey guys, thanks in advance for looking or helping me.

I'm working with a pricing spreadsheet that has some cells for our sales team to fill out. They would be just hand keying a Y into the cells that pertain to a customer and it calculates a price based on the customer's needs.

Anyway, there is a portion dedicated to shipping where if they place a Y under "Customer pickup" it should automatically black out the cells that pertain to shipping costs.

Here's what cells are in question:

If a Y is put into E7 - cells E46:E49, E51:E54 and E56:E59 should be filled in with black.
If a Y is put into E8 - cells E31:E34, E36:E39 and E41:E44 should be filled in with black.


Thanks again! Much love <3

[MrShorty]

Seems like it should be standard conditional formatting using a formula: https://support.office.com/en-us/art...B-F1951FF89D7F

[njsdca]

Oh god.

It's that easy -_- haha thank you for pointing me, I don't know why I couldn't make that make any sense.