Forum Discussion

Gerald_Rowe's avatar
Gerald_Rowe
Copper Contributor
May 30, 2021
Solved

Copying conditional formatting by scrolling

In the attached spreadsheet, e.g. the FAME 3h sheet, I have entered calculations and conditional formatting in cells AD39 to AI39, then scrolled these cells down to row 117 to copy the calculations and conditional formatting. The former worked correctly, and the latter also appeared to do so. However, more careful analysis subsequently showed that the conditional formatting was absent from several rows (e.g. 52, 53, 54, 64, etc.); the cells that should have been formatted but were missed have been manually changed to red font.

I am using the conditional formatting to identify outliers, using Peirce's criterion, for elimination from the data set prior to doing further calculations.

I am using Excel as part of Microsoft 365, version 16.0.14026.20246, on a Lenovo X230 computer running under Office 10.

  • Gerald_Rowe's avatar
    Gerald_Rowe
    May 30, 2021

    HansVogelaarGreat! Please tell me in detail how you did it. Thank you in advance - this has been quite a headache!

    Gerald

3 Replies