+ Reply to Thread
Results 1 to 5 of 5

Simple Cell Shading with different than default colors?

  1. #1
    Registered User
    Join Date
    04-09-2007
    Posts
    25

    Simple Cell Shading with different than default colors?

    Hi,

    is it possible to shade a cell (cells) with different colors than those present in the the Table with Conditional formatting/Format-Cells-Pattern-Shading ?
    E.g. I want the cell(s) to have a lighter blue than the default Cyan (lowest row in the colour table).

    Is it possible - how?

    My cells would sit in say A4, A18, A33, A47 etc, etc (irregularly)

    Joe

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,445
    Tools > Options > Colo(u)r > Modify

    hth

    dave

  3. #3
    Registered User
    Join Date
    04-09-2007
    Posts
    25
    Quote Originally Posted by sweep
    Tools > Options > Colo(u)r > Modify

    hth

    dave
    Thx! Found it.
    So it is applicable for the current File, also when I open it on another machine, right?

    Joe

  4. #4
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,445
    Yes it is, unless that other machine has some massive restriction on the colours available to it, which is highly unlikely.

    Dave

  5. #5
    Registered User
    Join Date
    04-18-2007
    Posts
    9
    Is it possible based on conditional check?
    Example.

    IF validation on a cell is TRUE color is yellow
    Else color is green

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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