ExcelBanter - 2007 Conditional Formatting, copying

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - 2007 Conditional Formatting, copying (https://www.excelbanter.com/excel-discussion-misc-queries/178496-2007-conditional-formatting-copying.html)

robert morris

2007 Conditional Formatting, copying

Using Office 2007, Formula =h12=max(h12,j12,l12,n12p12,r12) Formating
applies to h12:r12

I cannot copy formating down the sheet because Excel changes everything to
Absolute instead of Relative.

What have I done?

Bob

All times are GMT +1. The time now is 11:59 PM.