font colour change

  1. N

    Change the text colour of a specific cell if it is equal to another specific cell, if not leave as default colour

    for example if cell C2 is equal to cell F2 then C2 font colour should change to green, if it not equal then C2 should change font colour to red I realise this is simple, but I am a beginner with these functions. I am using Excel for Mac 2011. much appreciated. NL
  2. B

    Automatic Conditional FONT Color

    Fellow Forum Members, I have a lot of cells containing numbers and with dark colored highlights applied that makes the numbers hard to read. I also have other cells with colors like Yellow that is easy to read the black colored fonts. What conditional formula can I use to change Black Font...
  3. H

    Conditional Formatting Word Cloud

    My boss has seen a word cloud and now wants me to create one (in Excel 2003). Problem, I can't use Wordle for security reasons. Partial solution - I have used the (mighty!) Chandoo's solution to create a cell populated with words with font size based on frequency of use. However Chandoo's...
  4. T

    Validation list font change

    Is it possible to change the font for a validation list, specifically to change the colour of characters 11 and upwards for the names that appear in the drop down list? I've tried changing the source list cells but it doesn't change what appears in the drop down list. Any help would be most...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...