Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2013
    Posts
    1

    Unanswered: copy conditional formatiing in excel

    Dear,
    I have 20 rows and 10 columns in a sheet.
    In first row i use conditional formatting as equal to =max($D$6:$M$6) and the number with maximum value shown with a specific color, suppose its blue.

    Now i want to use this formula conditional formatting for every raw and data is different in every raw. Therefore i cant do paste special and i have to type formula in every row again and again.

    is anyone there have a shortcut to copy conditional formatting with formula or any other mode by which i don't need to type formula in all rows.

  2. #2
    Join Date
    Apr 2014
    Posts
    1
    any help this

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Create a vb macro
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •