copy/paste some conditional highlighting rules across multiple cells which have different "data formats"
G'Day
I would like to copy/paste some conditional highlighting rules across multiple cells which have different "data formats".
In particular, highlight "red" every cell less than zero, "green" for positive cells, "yellow" for zero, where some cells are currencies, some are percentages, some just plain numbers.
Copy/paste Style takes the entire format, stuffing up the already defined "data formats" (of %, currencies (Dollars/Euros/THB).
Appreciate any assistance
George
MacBook Pro (Retina, 13-inch,Early 2015), OS X El Capitan (10.11.3), Numbers