Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Multiple Conditional Formatting Problem

  1. #1
    New Member
    Join Date
    Nov 2017
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Multiple Conditional Formatting Problem

    Hello, everyone!

    Thanks in advance for devoting your time to my problem.

    I am stuck at a conditional formatting of a range of cells (do not have a problem when formatting one single cell but would like to avoid copy/pasting the formatting each time).

    - I want to achieve the following:

    Higlight each cell in a range if containing a specific text (let's say "YES") and if the date associated with the column which that cells belongs to has passed. Not sure if this was clear enough, so I will try to explain it in another way.

    If a cell containing specific text (i.e. "YES") is in the column "C" and this column (actually cell "C1") is associated with a date that has passed, I want that cell highlighted with a specific color. Now, where I am stuck at is applying the conditional formatting to the whole range. It is probably a trivial question for many but I am still in the process of learning.

    For single cells I am using the formula : =AND(C1
    I hope I was not too confusing.

    Best regards,
    MJ

  2. #2
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    15,953
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Multiple Conditional Formatting Problem

    Quote Originally Posted by Miodrag J View Post

    For single cells I am using the formula : =AND(C1< today(), c2="YES" ).

    So what i want to do is for example apply this conditional formatting the range c2:e10. how arrange custom formula so that it responds change of dates in columns c1:e1 and above mentioned specific text each particular cell range?

    I hope I was not too confusing.

    Best regards,
    MJ


    Select cells C2:E10 and enter this CF formula
    =AND(C$1< TODAY(), C2="YES")

    Excel will automatically adjust the formula for each cell.

    Forum TIP: The bulletin board editor sometimes interprets < and > symbols as HTML code. When you use them here in a formula, put a space before and after them.
    Last edited by AlphaFrog; Oct 3rd, 2018 at 03:28 PM.
    Paste your Excel data to the forum...
    MrExcel HTML Maker or Excel Jeanie

    How to post your vba code
    [CODE]your VBA code here[/CODE]
    The # button in the forum's editor will apply CODE tags around your selected text.

Some videos you may like

User Tag List

Tags for this Thread

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
  •