+ Reply to Thread
Results 1 to 4 of 4

background colours to improve readability

  1. #1
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    background colours to improve readability

    Do any of the templates/backgrounds offer the user a white background with every fifth row and column an off-white colour?

    My document will be read by LOADS of people, so I want to be able to follow my eye across. A soft system like that lets someone scroll across twenty columns and see they're still on the same row. It's like writing 7 Oct 2013 instead of 07/10/2013. It makes sense whether you use UK dd/mm/yyyy or US mm/dd/yyyy. People say 'October' not 'month no 10.' That's my logic and design principle.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: background colours to improve readability

    See attached file. I've used conditional formatting with this formula when A2:P43 were selected:

    =OR(MOD(ROWS($A$2:A2)-1,5)=0,MOD(COLUMNS($A$2:A2)-1,5)=0)

    Hope this helps.

    Pete
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    12-11-2013
    Location
    St Moritz, GR, Switzerland
    MS-Off Ver
    Excel 2010
    Posts
    187

    Re: background colours to improve readability

    Of course, my friend conditional formatting - thanks. Is a consistent pattern possible whether filtered or not?

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: background colours to improve readability

    Or

    Convert it to Table so that you can get some kind of predefined designs


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 08-28-2013, 09:19 AM
  2. Formatting chart data to improve readability
    By hockey99 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-27-2011, 04:21 AM
  3. How do I improve code readability
    By j_Southern in forum Excel General
    Replies: 7
    Last Post: 01-20-2011, 08:06 AM
  4. improve the readability of my graph
    By oresto in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-24-2008, 05:33 PM
  5. Replies: 2
    Last Post: 05-11-2007, 06:11 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1