+ Reply to Thread
Results 1 to 2 of 2

Font colour based on Cell colour

  1. #1
    Registered User
    Join Date
    04-16-2016
    Location
    Stoke-on-Trent, UK
    MS-Off Ver
    MS Office 2016 for Mac
    Posts
    7

    Font colour based on Cell colour

    Hey guys!

    My query is, is it possible to conditionally format cells that if I highlight a cell grey the font colour will be black and any cell left that is uncoloured the font colour will be white?

    Basically what I have is data that is calendarised by month and for the coming months the cells are uncoloured to state that the numbers are forecast number and month on month I get the 'actual' numbers, these get entered and I highlight the cell grey to state that info is actual and not forecast.


    Many thanks

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Font colour based on Cell colour

    There is no built-in function in Excel that can detect the fill color of a cell, so what you are describing cannot be done with conditional formatting. What you are describing requires VBA.

    I can think of two approaches. One would be to add a button to your sheet. When you want to color a cell gray, select the cell then click the button. Something similar could be done with right-click or double-click.

    I would be happy to help if you are interested in a VBA solution , but I can't be more specific without seeing your file.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. [SOLVED] Changing Font Colour based on cell contents
    By liamfrancis2013 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2018, 10:09 AM
  2. Replies: 6
    Last Post: 04-11-2016, 09:48 AM
  3. [SOLVED] Search cells based on student name, cell background colour and return a tally for colour
    By drof_06 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-26-2016, 04:31 AM
  4. font colour change based on adjacent cell value
    By nigamnigam in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-20-2015, 08:52 PM
  5. Replies: 2
    Last Post: 02-22-2015, 11:52 AM
  6. Replies: 1
    Last Post: 09-12-2013, 02:09 PM
  7. Use VBA to change font colour of a cell based on its own value (date)
    By grahamc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2012, 03:57 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