Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Conditional Formating

  1. #1
    Board Regular proficient's Avatar
    Join Date
    Apr 2012
    Location
    Karachi, Pakistan.
    Posts
    699
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Conditional Formating

    Hi All,

    I am here to ask you that let say if I have a table range A1:K10, all the cells housing dates, what I want to do is that if any cell have a SUNDAY the cell auto highlighted in red... please advise the formula...
    Regards,

    Kamran Mumtaz
    PAKISTAN.

    --------------------------------------------------------------------------------------------------------------------------------------------------------
    Playing with excel -
    2007

    Want to post a small screen shot? Try this Excel jeanie,

    Try searching for your answer first, see how

  2. #2
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    5,762
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Conditional Formating

    Like this:

    =WEEKDAY(A1)=7
    [code]your code[/code]

  3. #3
    Board Regular proficient's Avatar
    Join Date
    Apr 2012
    Location
    Karachi, Pakistan.
    Posts
    699
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Formating

    I have selected the whole range and type your given formula in conditional formating but nothing is changed...
    Regards,

    Kamran Mumtaz
    PAKISTAN.

    --------------------------------------------------------------------------------------------------------------------------------------------------------
    Playing with excel -
    2007

    Want to post a small screen shot? Try this Excel jeanie,

    Try searching for your answer first, see how

  4. #4
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    5,762
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Conditional Formating

    Maybe there are no Sundays in the range or maybe your dates are text values that look like dates.

    You can test if they dates are real Excel dates by using the formula =ISNUMBER(A1) which should return TRUE.
    [code]your code[/code]

  5. #5
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    19,395
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Formating

    Hi

    It should be

    =WEEKDAY(A1)=1
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

  6. #6
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    5,762
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Conditional Formating

    Quote Originally Posted by pgc01 View Post
    Hi

    It should be

    =WEEKDAY(A1)=1
    Of course!
    [code]your code[/code]

  7. #7
    Board Regular proficient's Avatar
    Join Date
    Apr 2012
    Location
    Karachi, Pakistan.
    Posts
    699
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Formating

    Still not working... Do you have any idea why...?
    Regards,

    Kamran Mumtaz
    PAKISTAN.

    --------------------------------------------------------------------------------------------------------------------------------------------------------
    Playing with excel -
    2007

    Want to post a small screen shot? Try this Excel jeanie,

    Try searching for your answer first, see how

  8. #8
    MrExcel MVP
    Join Date
    Apr 2006
    Posts
    19,395
    Post Thanks / Like
    Mentioned
    10 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Formating

    It works for me.

    Please you post how you are setting it up, step by step.
    Kind regards
    PGC

    To understand recursion, you must understand recursion.

  9. #9
    Board Regular proficient's Avatar
    Join Date
    Apr 2012
    Location
    Karachi, Pakistan.
    Posts
    699
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Conditional Formating

    I have a range from L6:Q12

    First I have selected the whole range then go to "NEW RULE" in C.F, clicked on "Use a formula to determine which cells to format" then type your given formula (Replace A1 with L6) then selected the color from format and hit the enter... Please tell where I am doing wrong...?
    Regards,

    Kamran Mumtaz
    PAKISTAN.

    --------------------------------------------------------------------------------------------------------------------------------------------------------
    Playing with excel -
    2007

    Want to post a small screen shot? Try this Excel jeanie,

    Try searching for your answer first, see how

  10. #10
    Board Regular
    Join Date
    Sep 2013
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional Formating

    hai,
    select the range and go to conditional format - new rule and use

    =+WEEKDAY($A1,1)=1

    Regards
    witson

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •