Results 1 to 4 of 4

Thread: EXCEL - Fx IF colour coding Text

  1. #1

    EXCEL - Fx IF colour coding Text



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Forum

    I have a Formula in excel - =IF(H23>H7,''good'',''bad'') how can I make the ''good'' show in green font and the ''bad'' in red.

    Appreciate any help - Gary

  2. #2
    Quote Originally Posted by garyrp View Post
    Dear Forum

    I have a Formula in excel - =IF(H23>H7,''good'',''bad'') how can I make the ''good'' show in green font and the ''bad'' in red.

    Appreciate any help - Gary

    Hi Gary,

    With conditional formatting- use the same formula.

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Select Range, Go to Home|Conditional Formatting|New Rule:

    Select "Format only cells that contain" from top section

    Then in bottom section, select "Cell Value", then "Equal To", then enter: ="good"

    Click Format and choose from Fill tab.

    Click Ok, then click New Rule and repeat with ="bad" and select red from Fill tab.


  4. #4
    Thank you very much - excellent response

Posting Permissions

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