+ Reply to Thread
Results 1 to 5 of 5

I don't know how to give a title to this but it involves EQUALS

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    China
    MS-Off Ver
    Excel 2007
    Posts
    1

    I don't know how to give a title to this but it involves EQUALS

    Ok. So I have my document which has the dates on the top row (H5:AI5). I have already conditional formatted it so it will highlight the weekends.

    Now the problem, further down in my document (H35:AI35, H65:AI95, H65:AI95,...), I want it to show the dates too. So what I have done is equal them to the top row, e.g. in H35, I formatted it as =H5. However, it doesn't apply the conditional formatting. Is there a fast way that I can equal the conditional format together as well?

    I hope there's an easier way coz I'm lazy to apply this conditional format to every row which shows the dates (it's a lot).

    Hope you can help asap. Thanks!
    Last edited by samsonchung; 02-06-2014 at 07:18 AM.

  2. #2
    Valued Forum Contributor adyteo's Avatar
    Join Date
    01-10-2013
    Location
    Calgary
    MS-Off Ver
    Excel 2010
    Posts
    540

    Re: I don't know how to give a title to this but it involves EQUALS

    select your cells (e.g. H5) and click Format Painter
    then click on your range (H35:AI35, H65:AI95, H65:AI95,...) and the conditional formatiing will be pasted
    Click on the star if you think I helped you

  3. #3
    Forum Contributor
    Join Date
    01-11-2013
    Location
    Sweden
    MS-Off Ver
    MS 365
    Posts
    188

    Re: I don't know how to give a title to this but it involves EQUALS

    Hi,

    You can copy the cells and then paste special and choose format.

    /Masun

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,748

    Re: I don't know how to give a title to this but it involves EQUALS

    on condition formatting you need to apply to that range
    at the moment you have H5:AI5

    =$H$5:$AI$5,$H$35:$AI$35, $H$65:$AI$95, $H$65:$AI$95

    but will depend on how you have written the formula for the conditional formatting - if it will apply OK
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: I don't know how to give a title to this but it involves EQUALS

    Hi, You said it yourself. Your post does not comply with Rule 1 of our Forum RULES. Most requests here by definition involve 'equals' so your title adds nothing. Your post title should accurately and concisely describe your problem, not your anticipated solution.
    If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. Give Helper Column a Title Cell
    By Gard5096 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2014, 07:00 PM
  2. Replies: 1
    Last Post: 04-03-2012, 11:33 AM
  3. Looking for formula that involves 2 columns
    By gerryger in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-03-2009, 06:48 AM
  4. Difficult to give Subject title
    By wendell in forum Excel General
    Replies: 4
    Last Post: 01-10-2007, 11:17 AM
  5. If cell equals, give total of another cell
    By Lori Burton in forum Excel General
    Replies: 2
    Last Post: 01-12-2006, 12:35 PM

Tags for this Thread

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