PDA

View Full Version : Conditional Formatting from one row to another



eric.leonard
04-18-2016, 09:01 AM
I was wondering if there was some way I can copy a conditional format from one row to another with out having to update all of the rules for the new row to reflect the updated reference cell.

I have rows 5 thru 8 set but I ultimately want to get up to 500 rows. To do each rule it takes roughly 10 mins per column to adjust when I just copy and special paste formatting.

:banghead:

Thank you.

Bob Phillips
04-19-2016, 05:19 AM
If you go into the CF, you should be able to update the range that the CF is applied to.

eric.leonard
04-19-2016, 05:43 AM
That is what is taking so long, I was hoping there was some code I could input to have the system updated the rules for me.

Bob Phillips
04-19-2016, 06:55 AM
Long? Changing say $A$1 to $A$1:$A$10 takes a long time?

eric.leonard
04-20-2016, 11:11 AM
I set up the rules for a row, and then copy and paste special formatting and then have to go to each rule for the new line to update the rule to change the formating.

example:

=$A$1="Y" $A$1:$T$1 = row rules
=$A$1="Y" $A$2:$T$1 = copied rules

I have to go update copied rule to =$A$2="Y" for all the rules pertaining to that row (about 20 rules for each row), need to do 500 rows.

This is what I mean by taking so long. I have to edit each conditional format for specific blocks.

That is what I was asking if there was a quicker way to update the rules not the applied to.

Bob Phillips
04-20-2016, 01:56 PM
No, you select all 500 rows, row 1 first, and use

=$A1="Y"

notice, no $ before the 1