+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting Cells Based on Text On Another Cell

  1. #1
    Registered User
    Join Date
    02-07-2022
    Location
    Mississippi, USA
    MS-Off Ver
    Windows 10
    Posts
    1

    Conditional Formatting Cells Based on Text On Another Cell

    Hello, I am fairly new to conditional formatting and am having troubles creating a formula for the below scenario. I would like to color code the cells in column B thru G that are below a certain value (eg:5) , IF the text on Column A is "Closing Stock". I am attaching a test file for your reference. I have been trying =AND(A:A='Closing Stock,$B:$G<5), but that's not working. Any help to resolve this is greatly appreciated. Thank you

    Manoj
    Attached Files Attached Files

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,866

    Re: Conditional Formatting Cells Based on Text On Another Cell

    =AND(B2<5,$A2="Closing Stock")

    See attached

    You write a conditional formatting formula as though it applied only to the cell at the upper left corner of the entire range you want it to apply to. Then Excel will remap it to the other cells using the same rules for absolute and relative references that it uses on worksheets. Here is a quick introduction.

    Also you must use $A to make the reference absolute since you are formatting cells in more than one column.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Inserting text to cells based on conditional formatting
    By mhanna112 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-05-2021, 02:45 AM
  2. conditional formatting fill cells based on text, how to find sum based on CF colour
    By tubbybear in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-27-2016, 12:04 PM
  3. [SOLVED] Conditional formatting formula based on text in two cells
    By lionrookie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2014, 12:50 PM
  4. Replies: 2
    Last Post: 07-28-2013, 03:28 PM
  5. [SOLVED] Conditional Formatting (changing color) in one cell based on text in two cells
    By Chadyoung1 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-14-2013, 04:26 AM
  6. Conditional Formatting based on text in previous cells
    By avidcat in forum Excel General
    Replies: 3
    Last Post: 07-14-2012, 01:01 PM
  7. [SOLVED] Conditional formatting of adjacent cells based on text in cell
    By elderain@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2006, 07:20 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