+ Reply to Thread
Results 1 to 2 of 2

Cell A1 should always be conditionally formatted

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    Chicago
    MS-Off Ver
    Excel 2010
    Posts
    13

    Cell A1 should always be conditionally formatted

    Hi,

    I'm trying to format cell A1 in my workbook so that it is always colored green. I need this because I'm creating a shared workbook and I need/want this cell colored green so that the use knows to paste all info into this cell only. I've tried conditional formatting but when I close/reopen the workbook, the cell does not remain colored. Any info will help! Thank you!

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Cell A1 should always be conditionally formatted

    you could just change the cell fill color from the "Home Ribbon" under the Font category

    and if they are pasting data just have them paste using "Match Destination Formatting" which will keep the data filled in green
    Last edited by dosydos; 01-13-2016 at 01:34 PM.

+ 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. Carrying Conditionally Formatted Cell to New Sheet
    By tlombardi in forum Excel General
    Replies: 3
    Last Post: 03-26-2015, 11:20 AM
  2. [SOLVED] How to reference a conditionally formatted cell(s)
    By EXCELNEWCOMER in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-22-2013, 04:34 AM
  3. Need a macro to delete row based on conditionally formatted cell
    By twinklestar922 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2013, 06:47 AM
  4. how to copy a cell that has been conditionally formatted
    By Dexter Stagg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-27-2012, 05:03 PM
  5. How to count cell which are conditionally formatted?
    By parekhharsh_j in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2011, 02:53 PM
  6. Reading a conditionally formatted cell
    By akronpow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2007, 03:57 PM
  7. Replies: 3
    Last Post: 01-25-2007, 06:37 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