View Single Post
  #4   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

I have tried the solution. While it copies the conditional formatting to the additional range of cells. It always the initial cells in the formula rather than a relative
"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 ?