Cells color change based on another cell's color

[craig2525]

Hi all,

I need to change the cells in a row based on the color of one cell. Column E has a conditional format of specific text of clock in to change green and clock out to change red. I need the cells of columns A, B, C and D to change to green or red based on column E.

 

[Joe4]

Just expand your current Conditional Foramtting Rule to apply to the other columns as well.
You may just need to lock down any current column references in the Conditonal Formatting formula.

If you need any help with that, please post your current Conditional Formatting Rule/formula.

 

[craig2525]

This is what I have now. Can you show me "expand" the current conditional formatting?

 

[Joe4]

OK, instead of using the "Format all cells based on their values" or the "Format only cells that contain" Rule Types, use the "Use a formula to determine which cells to format".
So select columns A:E, then use this formula for green:

=$E1="clock in"

and then this formula for your red rule:

=$E1="clock out"

 

[craig2525]

Works perfect. Thank you.

 

[Joe4]

You are welcome!
Glad I was able to help.