+ Reply to Thread
Results 1 to 4 of 4

2016 Conditional Formatting Only format Columns with Certain text in first cell

  1. #1
    Registered User
    Join Date
    10-23-2020
    Location
    Sacramento, CA
    MS-Off Ver
    22016
    Posts
    2

    2016 Conditional Formatting Only format Columns with Certain text in first cell

    I have sheet that is completely blank other than conditional formatting that checks input for double spaces and unabbreviated words. Users paste their information with rows and columns in different order so currently every formatting rule checks the entire page. I would like to set the formatting to only check cells that have certain text in Row A for conditions in the rest of this row. How would I go about this?
    For example:

    I want to fill cells in the Status_Code column with a color if they don’t contain the text “A1” but I would like to leave all other columns unaffected. Please Help.
    Attached Files Attached Files
    Last edited by Zblankenship87; 10-23-2020 at 06:34 PM. Reason: Adding Attachemnet

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    3,179

    Re: 2016 Conditional Formatting Only format Columns with Certain text in first cell

    Hi,
    Please upload the sample file with the error in subject.

  3. #3
    Registered User
    Join Date
    10-23-2020
    Location
    Sacramento, CA
    MS-Off Ver
    22016
    Posts
    2

    Re: 2016 Conditional Formatting Only format Columns with Certain text in first cell

    Sample sheet attached.

  4. #4
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Re: 2016 Conditional Formatting Only format Columns with Certain text in first cell

    Select the entire sheet and apply this Conditional formula: =AND(A$1="Status_Code",A1<>"A1",ISBLANK(A1)=FALSE).

+ 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. [SOLVED] Formula in Conditional Formatting in the format $A2:$D2 (only columns locked)
    By JasonZA in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-22-2018, 10:17 AM
  2. Conditional Formatting in Excel 2016
    By Mansfieldexcel in forum Excel General
    Replies: 2
    Last Post: 03-21-2016, 01:56 PM
  3. Conditional Formatting - Format Red if cell does not contain Text (30 options)
    By CHRYSTALMCKAY in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-08-2016, 10:05 AM
  4. [SOLVED] Format Spreadsheet - split text columns, rearrange columns, conditional format
    By lacke81c in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2015, 11:50 AM
  5. Replies: 4
    Last Post: 03-13-2015, 02:32 AM
  6. Replies: 5
    Last Post: 05-25-2014, 12:12 AM
  7. Replies: 2
    Last Post: 07-28-2013, 03:28 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