Results 1 to 4 of 4

Column random colour format

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-16-2009
    Location
    Sheffield
    MS-Off Ver
    Microsoft 365 Version 2404
    Posts
    118

    Column random colour format

    Is there any way to set conditional formatting or any other method to randomly change the cell colour as the text heading changes each time looking down the list.

    I am basically looking for an auto method of changing the cell appearance as the text changes as per example, colours are not important and if easier could just alternate from say dark to light where there is a change
    Random 03.png


    Many thanks
    Last edited by junada0; 05-24-2017 at 06:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 12-23-2015, 02:08 PM
  2. Replies: 2
    Last Post: 11-06-2014, 05:07 PM
  3. [SOLVED] Cond Format Colour C if A blank, or Colour diff if A blank BUT B contains "text"
    By marsham in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-10-2013, 03:19 PM
  4. Colour change column chart based on cell colour
    By Alice21 in forum Excel General
    Replies: 11
    Last Post: 04-05-2011, 10:10 AM
  5. Replies: 2
    Last Post: 06-22-2010, 07:55 AM
  6. Random colour change on cell content input
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 04-13-2010, 08:23 PM

Tags for this Thread

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