copy conditional format without using format painter
Select the cell containing the Conditional Format you want to copy
CTRL-Click on the other cell (or range of cells such that source cell
remains seleceted)
Choose Format-Conditional Formatting
You will see the formatting already applied to the source cell
Click OK
"MsConfused" wrote:
Hi,
I am looking to copy the conditional formatting of a cell into another cell
without copying any other formatting (eg borders). Neither Format painter
nor paste special/format allows me to do this.
Can anyone advise?
Thank you
|