Currently Being ModeratedFeb 18, 2013 6:18 AM (in response to derroque)
You can Copy Format / Paste Format to get it started but you'll have to edit the cell reference so it points to the header cell in the new column. For your simple rule where the format in the entire column is comparing to one specific cell in the header, that's not such a big deal. For some rules, though, it can be a pain. For instance if you have a format in A2 that compares itself to the cell next to itself (B2) and you would like to fill that rule down the entire column so each cell is comparing iteslf to the one next to it, you cannot.
Currently Being ModeratedFeb 18, 2013 10:41 PM (in response to derroque)
As Badunit says, it's no big deal in this case to select all the cells in B, then recreate the rule with reference to B1.
For the more complicated case BU describes. there is a bit of a short cut: Select all the cells to be given the rule and set the cell reference(s) to the one needed for the first cell.
Select each of the other cells in turn and:
-- click the cell reference to select it.
-- click the cell to be referenced.
-- (repeat for other cell references in that set of rules)
Repeat with each of the remaining cells to be formatted.
Currently Being ModeratedFeb 20, 2013 1:27 AM (in response to Barry)
Thanks for your help guys.
When I got you right, there is no other way than recreating the rule for every new column. That's no big deal for one new column with one rule. But I have several columns and I use the same three rules for each of them. It is so annoying to add 3*X rules per hand. I hoped that Apple had included a better rule management tool :/
Currently Being ModeratedFeb 20, 2013 9:41 AM (in response to derroque)
"I hoped that Apple had included a better rule management tool :/"