Copying conditional formatting for new rows

[Nikos_K]

Hi all.

Apologies if my question seems basic I am an Excel beginner and do a lot of Google searches to find answers.

I have a cell in Column V in which you can select from a list. The list choices are "Underway" "Overdue" Completed" and "n/a" . When the Cell in Column V is selected it's formatting changes depending on selection.
I then wanted Columns A to U to match the colour formatting of column V.


View attachment 59021

I use the following conditional formatting to rules to achieve this.


View attachment 59022

My problem is that I now have to do this for every single row and I wanted to know how I can copy this formatting for every row using the corresponding cell in column V for each row.

Much thanks in advance
Nikos

 

[BSALV]

i think you want this :
for example "overdue", change the "applies to" to "$A$2:$U$1000", so it works for that range.
then be sure your active cell is somewhere in the 1st row of that range = row 2
then "edit" the formula for "overdue" and change it in =$V2="overdue"
Click "ok" and "apply" and check again your changes

 

[Peter_SSs]

Duplicate to: Copying conditional formatting for new rows

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.