View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default 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