+ Reply to Thread
Results 1 to 13 of 13

creating condidional formating formula

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    39

    creating condidional formating formula

    I would like to stand out records where date = current year and name = john. unfortunately i don't know how to write formula in conditional formating:/
    Attached Files Attached Files
    Last edited by radek225; 09-28-2015 at 08:07 AM.

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,582

    Re: creating condidional formating formula

    Select A2:C13 and use below formula in Conditional Format
    =and(year($a2)=year(today()),$B2="John")
    Please Login or Register  to view this content.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: creating condidional formating formula

    Try using
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    09-23-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    39

    Re: creating condidional formating formula

    Quote Originally Posted by nflsales View Post
    Select A2:C13 and use below formula in Conditional Format
    =and(year($a2)=year(today()),$B2="John")
    Please Login or Register  to view this content.
    Doesn't work - error with syntax

  5. #5
    Registered User
    Join Date
    09-23-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    39

    Re: creating condidional formating formula

    Quote Originally Posted by jason.b75 View Post
    Try using
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Doesn't work - error with syntax

  6. #6
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: creating condidional formating formula

    Does work - how did you try to use it?

    ** this applies to both suggestions that were provided **

  7. #7
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,582

    Re: creating condidional formating formula

    see the attached file
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    09-23-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    39

    Re: creating condidional formating formula

    Quote Originally Posted by jason.b75 View Post
    Does work - how did you try to use it?

    ** this applies to both suggestions that were provided **
    just opened conditional formating=>new rule=> and past yours formulas.
    Could You attach file with implement formula? Then I will know what's wrong

  9. #9
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,041

    Re: creating condidional formating formula

    Would be better if you pasted the formula you have entered, then we could tell you what's wrong with it, probably at a glance.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  10. #10
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: creating condidional formating formula

    Quote Originally Posted by radek225 View Post
    just opened conditional formating=>new rule=> and past yours formulas.
    Could You attach file with implement formula? Then I will know what's wrong
    What's wrong with the file in post 7?

    I've just opened it and it looks like it's doing exactly what you asked for.

    Rows 3,7,10 and 11 are green, the rest are not. No sign of any errors.

    edit:-

    Looking at your sheet name, does your computer have Polish regional settings?

    If it does then you might need to replace , with ; in the formula (the same applies to any formula).
    Last edited by jason.b75; 09-28-2015 at 07:38 AM.

  11. #11
    Registered User
    Join Date
    09-23-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    39

    Re: creating condidional formating formula

    Quote Originally Posted by Special-K View Post
    Would be better if you pasted the formula you have entered, then we could tell you what's wrong with it, probably at a glance.
    Quote Originally Posted by jason.b75 View Post
    What's wrong with the file in post 7?

    I've just opened it and it looks like it's doing exactly what you asked for.

    Rows 3,7,10 and 11 are green, the rest are not. No sign of any errors.
    Ok guys. I past "and.." but in my language should be "oraz..." now it's ok., but tell mi please. Where could I choose e.g. should be marked only one column not 3?

  12. #12
    Registered User
    Join Date
    09-23-2015
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    39

    Re: creating condidional formating formula

    Quote Originally Posted by jason.b75 View Post
    What's wrong with the file in post 7?

    I've just opened it and it looks like it's doing exactly what you asked for.

    Rows 3,7,10 and 11 are green, the rest are not. No sign of any errors.
    Ok guys. I past "and.." but in my language should be "oraz..." now it's ok., but tell mi please. Where could I choose e.g. should be marked only one column not 3?

  13. #13
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: creating condidional formating formula

    Quote Originally Posted by radek225 View Post
    Where could I choose e.g. should be marked only one column not 3?
    Just change the 'Applies to' range in the conditional formatting editor.

+ 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: 10-09-2014, 08:29 AM
  2. [SOLVED] Conditional Formating or Formula?
    By SVTF in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-04-2014, 09:49 PM
  3. Conditional formating-What formula do i need to use in conditional formating
    By warrima in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2009, 12:33 AM
  4. Formating with a formula
    By loulou in forum Excel General
    Replies: 3
    Last Post: 04-06-2006, 10:10 AM
  5. Tutorial on creating & formating a word doc from excel
    By STEVE BELL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2005, 02:55 PM
  6. [SOLVED] Formating the text of a formula?
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 10:05 AM
  7. Formating the text of a formula?
    By Manos in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1