+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    cebu,philippines
    MS-Off Ver
    Excel 2010
    Posts
    44

    Conditional formatting

    Hi guys,

    I want to highlight b1 if a1 is not blank. how to format this one?

    thanks
    blessed are those who share whats theirs

  2. #2
    Forum Contributor
    Join Date
    06-11-2014
    MS-Off Ver
    Office 2003, 2007 & 2010
    Posts
    119

    Re: Conditional formatting

    Use this formula in the conditional formatting dialogue window, then set your colours

    Please Login or Register  to view this content.
    Be carefule though as the reference to B1 is not absolute so if you dragged cell B1 across to C1, it would be looking at B1 instead of A1, same as a normal formula would. If you want it absolute, the change A1 to $A$1

  3. #3
    Registered User
    Join Date
    08-22-2013
    Location
    cebu,philippines
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: Conditional formatting

    thank you...

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Conditional formatting

    Quote Originally Posted by AranDG View Post
    Use this formula in the conditional formatting dialogue window...

    =IF(A1="",1,0)=0
    That can be reduced to:

    =A1<>""
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  2. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  3. Replies: 3
    Last Post: 11-04-2013, 12:47 AM
  4. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  5. Replies: 2
    Last Post: 09-19-2013, 10:34 AM
  6. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 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