Conditional formatting on several cells based on 1 unique cell condition

[Askalian]

Hi, there.

I would like to highlight in yellow a line of 12 cells (let's says A1 to A12) based on the conditionnal formatting of only one cell (let's say A13).

Possibly it's simple, but I don't find the answer.

Thanks for the kind help.

Frederic

[6StringJazzer]

What is the conditional formatting applied to A13?

The generic solution to this is to use a custom formula with absolute addressing. Let's say that you want to format A1 to A12 if A13 is 99.

Applies To range is $A$1:$A$12

Formula:

=$A$13=99

cf1.JPG

cf2.JPG

[Askalian]

Hi, 6 StringJazzer.

It works perfectly well. I am a little ashamed as I should have find it myself...

Thank you so much

Have a nice day.
Frederic

[6StringJazzer]

Glad to help, and thanks for the rep!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."