View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Plynth Plynth is offline
external usenet poster
 
Posts: 3
Default auto fill color of row



"Gary''s Student" wrote:

If you have already applied conditional formatting to a single cell, copy
that cell and pastespecial/formats across the entire row.
--
Gary''s Student - gsnu200753


"capital letter" wrote:

I have conditional formating & color in a cell, but I want to color the
entire row of conditional formating cell. Is there any option to do it ?

I am copying the results of a formula for conditional formatting to a range
of cells. I would like the formula references to change as well: (L3K3)
when copied would be (L4K4). Can this be done