Conditional Formatting

[Evie76]

Afternoon,

I need help with conditional formatting. If cell c10 is red i need J10, q10 and x10 to also turn red how do i go about doing this.

Thanks

Eve

 

[Joe4]

Conditional Formatting only runs off of values of cells, not off of formatting.
How is cell C10 being formatted red? If that is by Conditional Formatting, we can use the same rule being used for cell C10 for the other cells.
Just lock the column reference in your formula, i.e. $C

 

[Evie76]

If i put an x in C10 how would i get c10,J10, q10 and x10 to turn red (sorry to be a pain)

 

[Joe4]

Each of the cells you want formatted use the same Conditional Formatting formula:

=$C10="x"

So select each of these cells first, then go to Conditional Formatting and enter that CF formula and choose your red formatting option.

 

[Evie76]

Thank you so much

 

[Joe4]

You are welcome!