+ Reply to Thread
Results 1 to 4 of 4

Conditional format if formula has some text/numbers...

  1. #1
    Forum Contributor
    Join Date
    11-12-2016
    Location
    georgia,tbilisi
    MS-Off Ver
    Office 365 MSO (Version 2401 Build 16.0.17231.20008)
    Posts
    127

    Conditional format if formula has some text/numbers...

    Hello friends,

    I need to Conditionally format formula if it has some Numbers/text added is there any way? For example formula is this: =ROUND(SUMIFS(TS!$Z:$Z,TS!D:D,Notes!B81),0)

    Thanks in advanced...
    Last edited by kikola123; 06-30-2020 at 02:44 PM.

  2. #2
    Forum Contributor
    Join Date
    11-12-2016
    Location
    georgia,tbilisi
    MS-Off Ver
    Office 365 MSO (Version 2401 Build 16.0.17231.20008)
    Posts
    127

    Re: Conditional format if formula has some text/numbers...

    For example if above formula has added 2 (=ROUND(SUMIFS(TS!$Z:$Z,TS!D:D,Notes!B81),0)+2) it needed to be formated in different colour...

  3. #3
    Forum Contributor
    Join Date
    11-12-2016
    Location
    georgia,tbilisi
    MS-Off Ver
    Office 365 MSO (Version 2401 Build 16.0.17231.20008)
    Posts
    127

    Re: Conditional format if formula has some text/numbers...

    No answers?( NO way to execute this?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,626

    Re: Conditional format if formula has some text/numbers...

    Administrative Note:

    We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day - it has been only an hour since you posted. Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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: 6
    Last Post: 12-28-2021, 12:04 PM
  2. Replies: 3
    Last Post: 05-04-2020, 01:28 PM
  3. Replies: 3
    Last Post: 03-27-2019, 10:06 PM
  4. Conditional Format to search for text and numbers
    By brent_milne in forum Excel General
    Replies: 1
    Last Post: 05-15-2014, 02:48 PM
  5. [SOLVED] Need a 4th conditional format, Formula not right with =MAX and TEXT
    By Dibbley247 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-14-2014, 07:56 AM
  6. [SOLVED] Code to Properly Format numbers stored as text so they can be read by a formula
    By Student1990 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-15-2013, 05:06 PM
  7. Replies: 5
    Last Post: 12-29-2008, 05:48 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