Results 1 to 4 of 4

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

Threaded View

  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

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