Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Location
    UK
    Posts
    233

    Unanswered: Changing Font colour conditionally

    I want to change the colour of the font depending on the value that is entered into that cell.

    For example if the value is greater than 99 I want the font to be Red. I the value is less than 99 I want the font to be blue.

    Can anyone help me on this?

    Many thanks,

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy.

    What happens if it is exactly 99?

    I assume you have a range of cells that you want to have this happen to. Say the range is B4:J10, select that range, then go to Format > Conditional Format, and on the left, in the dropdown box, make sure it is "Cell value is", then in the middle dropdown choose "is greater than", then in the right box, type 99. Click the Format button on the middle right and set your font color. Click OK.

    While still in the Confitional Formatting dialog box, click on the Add button at the bottom, and choose same as above, only in the middle box, select "is less than", then click Format button and set your font color. Click OK. Click OK.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    May 2003
    Location
    UK
    Posts
    233
    Perfect - nice and clear and easy to understand -

    Thanks again

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Great. And it is appreciated that you came back with the results, too.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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