+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Text

  1. #1
    Forum Contributor
    Join Date
    03-14-2016
    Location
    United States
    MS-Off Ver
    MS Office 2013
    Posts
    102

    Conditional Formatting Text

    Hello,

    Is it possible to conditional format text based on the results of two cells in different worksheets?

    For example:
    If Column A: New York, Column B: 1

    then

    New sheet I have New York in Column A and I want the color of the cell to change based on whether Column B in the previous workshop is a 1 or 2?

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Conditional Formatting Text

    On Sheet2 select cell which will be colored and CF: Sheet1!B1=1
    If you change value of B1 on Sheet1 to different than 1, color on sheet 2 will be "blank"
    or
    if you want the same cell with different color (if Sheet1!B1=2) define in CF second rule: Sheet1!B1=2 and choose different color than first
    Last edited by sandy666; 03-11-2017 at 08:19 PM.

  3. #3
    Forum Contributor
    Join Date
    03-14-2016
    Location
    United States
    MS-Off Ver
    MS Office 2013
    Posts
    102

    Re: Conditional Formatting Text

    That works but does not let me use the conditional formatting green background with green text otherwise labeled as "Good"

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Conditional Formatting Text

    attach sample workbook with detailed description what you want to achieve and example of result

+ 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. Replies: 2
    Last Post: 04-10-2015, 12:12 PM
  2. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  3. [SOLVED] Conditional formatting to mark cells with on text strnig but lacking another text string
    By KArnoldColumbia in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2013, 04:15 PM
  4. Replies: 3
    Last Post: 11-04-2013, 12:47 AM
  5. [SOLVED] Conditional Formatting (Adding text and cell formatting)
    By fredjones in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-26-2012, 04:15 AM
  6. Replies: 9
    Last Post: 03-12-2012, 03:56 PM
  7. [SOLVED] Conditional Formatting based on Text within Text
    By George Lynch in forum Excel General
    Replies: 3
    Last Post: 05-05-2005, 03:06 PM

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