+ Reply to Thread
Results 1 to 10 of 10

Conditional formatting with determined formula - Different installed language problem

  1. 11-15-2016, 04:42 PM #1
    Villalobos
    Villalobos is offline
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Lightbulb Conditional formatting with determined formula - Different installed language problem

    Hi,

    I would need your help regarding a conditional formatting VBA issue. In the below mentioned code I use Hungarian language regarding Formula1 and my problem is that my colleagues have different installed languages (French, English, German and Turkish) on their PC so they do not see the conditional formatting.

    How should change the code in order to see the determinded conditional formatting formulas in different language?

    Thank you for your repons!

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 11-16-2016, 02:11 AM #2
    Villalobos
    Villalobos is offline
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Conditional formatting with determined formula - Different installed language problem

    Do you have any idea?
    Reply With QuoteRegister To Reply
  3. 11-16-2016, 02:55 PM #3
    Villalobos
    Villalobos is offline
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Conditional formatting with determined formula - Different installed language problem

    Does anyone know a solution?
    Reply With QuoteRegister To Reply
  4. 11-16-2016, 07:19 PM #4
    vichopalacios
    vichopalacios is offline
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Conditional formatting with determined formula - Different installed language problem

    Hi Villalobos

    Perhaps instead of breaking your head trying to automaticaly translate the formulas in C.F. you can use a "Worksheet Change" event.
    If you need some help on how to, just ask for it
    Barriers are there for those who don't want to dream
    Reply With QuoteRegister To Reply
  5. 11-17-2016, 02:41 AM #5
    Villalobos
    Villalobos is offline
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Conditional formatting with determined formula - Different installed language problem

    Hi,

    Thank you the feedback!
    Could you help me to figure out the Worksheet Change event?
    Reply With QuoteRegister To Reply
  6. 11-17-2016, 02:48 AM #6
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Conditional formatting with determined formula - Different installed language problem

    Hi

    You might also temporarily write the formula to a blank cell using the English formula, then read it back using the Formulalocal property to get the correct formula for the CF.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  7. 11-17-2016, 07:26 AM #7
    Villalobos
    Villalobos is offline
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Conditional formatting with determined formula - Different installed language problem

    Hi xlnitwit,

    Your idea sounds well, could you please help me to figure out the code?
    Reply With QuoteRegister To Reply
  8. 11-17-2016, 07:37 AM #8
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Conditional formatting with determined formula - Different installed language problem

    Basically like this
    Please Login or Register  to view this content.
    and repeat for the remaining CF section(s).
    Reply With QuoteRegister To Reply
  9. 11-17-2016, 08:30 AM #9
    Villalobos
    Villalobos is offline
    Forum Contributor
    Join Date
    12-23-2013
    Location
    Hungary
    MS-Off Ver
    Excel 2013
    Posts
    331

    Re: Conditional formatting with determined formula - Different installed language problem

    Thank you very much xlnitwit!
    Reply With QuoteRegister To Reply
  10. 11-17-2016, 08:40 AM #10
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Conditional formatting with determined formula - Different installed language problem

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Formatting formula problem
    By rajeshn_in in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-23-2016, 08:41 AM
  2. Count Cells Based on Colour Determined by Conditional Formatting
    By RanCanMan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2015, 09:45 AM
  3. [SOLVED] Conditional Formatting - Formula Problem?
    By KenMcN in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2014, 03:00 PM
  4. [SOLVED] formula problem w/ conditional formatting
    By edwinculanding in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-30-2013, 05:20 AM
  5. [SOLVED] Construct a formula on a pre-determined cell for a pre-determined duration of cells
    By Shaun Gemiver in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-03-2013, 11:14 AM
  6. Excel 2007 : Conditional Formatting in Excel 2007 - Format of one area determined by value outside
    By cbHRlady in forum Excel General
    Replies: 0
    Last Post: 12-09-2011, 08:37 PM
  7. Conditional Formatting formula problem
    By ddub25 in forum Excel General
    Replies: 3
    Last Post: 01-21-2010, 08:24 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1