+ Reply to Thread
Results 1 to 10 of 10

Using Conditional Formatting can I format a CELL based on another CELL's value?

  1. #1
    Forum Contributor
    Join Date
    03-30-2020
    Location
    Gibraltar, Gibraltar
    MS-Off Ver
    365
    Posts
    150

    Using Conditional Formatting can I format a CELL based on another CELL's value?

    I want to format a cell based on what I input on another cell
    Is this possible?
    Last edited by Michael Island; 09-12-2020 at 12:11 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Using Conditional Formatting can I format a CELL based on another CELL's value?

    Yes it is possible.

  3. #3
    Forum Contributor
    Join Date
    03-30-2020
    Location
    Gibraltar, Gibraltar
    MS-Off Ver
    365
    Posts
    150

    Re: Using Conditional Formatting can I format a CELL based on another CELL's value?

    How can it be done?

  4. #4
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Using Conditional Formatting can I format a CELL based on another CELL's value?

    Place an example file and explain the purpose. Or see https://www.youtube.com/watch?v=aomParo6vZ0

  5. #5
    Forum Contributor
    Join Date
    03-30-2020
    Location
    Gibraltar, Gibraltar
    MS-Off Ver
    365
    Posts
    150

    Re: Using Conditional Formatting can I format a CELL based on another CELL's value?

    Attached is the example
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Using Conditional Formatting can I format a CELL based on another CELL's value?

    The solution in the file.
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    03-30-2020
    Location
    Gibraltar, Gibraltar
    MS-Off Ver
    365
    Posts
    150

    Re: Using Conditional Formatting can I format a CELL based on another CELL's value?

    now the cell is permanently bordered and the cell cannot be un-bordered. Do I really need to tell you this not what I wanted?

  8. #8
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Using Conditional Formatting can I format a CELL based on another CELL's value?

    How about
    =C2=1

  9. #9
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Using Conditional Formatting can I format a CELL based on another CELL's value?

    the cell is NOT permanently bordered. Only the values 1-10 in C1 will border the cell.

  10. #10
    Forum Contributor
    Join Date
    03-30-2020
    Location
    Gibraltar, Gibraltar
    MS-Off Ver
    365
    Posts
    150

    Re: Using Conditional Formatting can I format a CELL based on another CELL's value?

    Hi,

    No more need for more solutions - I used your formula in the Conditional Format rule, I tweaked it a bit and it works perfectly for my needs.

    Thanks

+ 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. Conditional Formatting Based on Adjacent Cell *Format*
    By MacroPolo in forum Excel General
    Replies: 1
    Last Post: 05-18-2016, 09:59 AM
  2. Conditional Formatting - Format row based on cell value in specific column
    By Kite3 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2013, 12:23 AM
  3. Replies: 2
    Last Post: 07-28-2013, 03:28 PM
  4. [SOLVED] Workaround to Conditional Formatting based on a Format of another cell
    By sarkman22 in forum Excel General
    Replies: 5
    Last Post: 05-10-2013, 01:24 PM
  5. Using Conditional Formatting to format range based on one cell
    By panamakevin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2012, 09:50 PM
  6. Replies: 2
    Last Post: 12-21-2011, 06:01 PM
  7. Conditional Formatting 4+ conditions, format rows based on cell
    By nockam in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-12-2006, 06:12 PM

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