+ Reply to Thread
Results 1 to 3 of 3

conditional formatting to a cell (date and text)

  1. #1
    Registered User
    Join Date
    07-27-2014
    Location
    hong kong
    MS-Off Ver
    2010
    Posts
    2

    conditional formatting to a cell (date and text)

    Hi,

    There is a question

    If I want to have a conditional formatting to a cell which includes date and text

    Let's say in cell A1:

    20150215
    hello world

    I would like doing conditional formatting to this one to highlight this cell when it equals to today

    Anyone knows how to set the conditional formatting to this one? or any other combined formatting that can apply to a cell?

    Thanks so much :D

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: conditional formatting to a cell (date and text)

    Please Login or Register  to view this content.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-27-2014
    Location
    hong kong
    MS-Off Ver
    2010
    Posts
    2

    Re: conditional formatting to a cell (date and text)

    Thank you so much, that's what i need
    perfect!
    appreciated :D

+ 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: 1
    Last Post: 01-30-2014, 10:04 AM
  2. Replies: 1
    Last Post: 06-02-2013, 04:00 PM
  3. [SOLVED] Conditional formatting based on text in one cell, date in another
    By Chuck_N in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2013, 11:34 AM
  4. [SOLVED] Conditional Formatting based on a Date Cell and a text Cell.
    By Clark85 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-09-2013, 07:53 AM
  5. Conditional formatting based on text in cell and a corresponding date
    By livinglegend629 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2010, 05:10 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