Results 1 to 12 of 12

Conditonal Formatting (When a number appears, the cell to the right changes color)

Threaded View

  1. 06-19-2014, 10:39 AM #1
    managingcrap
    managingcrap is offline
    Forum Contributor
    Join Date
    09-15-2012
    Location
    las vegas
    MS-Off Ver
    excel 2007
    Posts
    147

    Conditonal Formatting (When a number appears, the cell to the right changes color)

    I'm trying to figure out a conditional formatting where if I have cell A1 as 1, then B1 will have a black color ( the cell block colored black). However, if i leave the A1 blank, then B1 is not colored.

    I tried conditional formatting and failed.

    Please see attached sheet.
    Attached Files Attached Files
    Last edited by managingcrap; 06-20-2014 at 12:55 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditonal formatting based on text in cell, then highlight entire row
    By emilyloz in forum Excel General
    Replies: 2
    Last Post: 06-05-2013, 11:03 AM
  2. Conditional Formatting applied only if a number appears more than 10 times?
    By BaronDJB in forum Excel General
    Replies: 2
    Last Post: 08-27-2010, 07:54 AM
  3. Conditonal Formatting a Cell Based on Other Cells
    By fasterthanyours in forum Excel General
    Replies: 14
    Last Post: 08-04-2009, 12:24 PM
  4. Obtain Conditonal format color
    By Jivo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2007, 11:24 AM
  5. [SOLVED] Applied color to excel cell but no color appears
    By chris_bartnick in forum Excel General
    Replies: 1
    Last Post: 12-05-2005, 11:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1