Conditional formatting on multiple tabs in a workbook

[Ozhatch]

I am working on a spreadsheet which has 8 tabs. All tabs have the same column headings, and up to 500 rows. I would like to set up several formulae for conditional formatting, but that can't be done if all the tabs are selected.

It's really painful to have to rewrite each of the 7 the formulae I require for each tab.

The formula is: for cells $A$2:$T$501

=$U2="Declined"

or one of 6 other conditions, with font formatting or cell color settings, or often both.

Can someone suggest a solution, please?

 

[AlphaFrog]

• Conditional Format one sheet
• Select cells A2:T501 and copy
• Right-click on cell A2 on another sheet and select Paste Special from the pop-up menu
• Paste Special dialog: Formats and OK
• Repeat for the other sheets

 

[Ozhatch]

Thanks, AlfaFrog, but that can't happen. I can understand that process working if I'm setting up the workbook from scratch, but I receive the workbook with information already entered. If I copy and paste I'll lose that information.

Sorry; I should have made that clear in my original post.

 

[AlphaFrog]

Paste Special: Formats doesn't paste cell values. Only cell formatting.

What am I missing?

 

[Ozhatch]

What am I missing?

You didn't miss anything, AlfaFrog; I did! I missed the paste special 'format'. My apologies...

...and my sincere thanks for your assistance.