+ Reply to Thread
Results 1 to 3 of 3

conditional formatting with one cell having a formula

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    16

    conditional formatting with one cell having a formula

    Hi all,

    This is the most simplest conditional formatting which is working except on some cells.
    I want to compare two columns cells
    ex : if A=B , then format A as green.

    Its working, the "formula" and "cell value contains" everything except for few cells.
    Cell B has formula's in it related to other cells. When i enter values in other cells, Cell B computes but A refuses to format "green".
    Why is this happening?

    If I just enter same value[ex 1, 1]in both the cells sans formula ,it highlights A green .
    I want to know , if the formula in cell B is causing the errors in formatting and if it is, can you please help me overcome it?

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: conditional formatting with one cell having a formula

    Hello aditi can you please upload a sample book ?

  3. #3
    Forum Contributor rajeshturaha's Avatar
    Join Date
    08-22-2012
    Location
    Assam, India
    MS-Off Ver
    Excel 2003, 2007
    Posts
    236

    Re: conditional formatting with one cell having a formula

    Aditi,
    I think the value in cell b in not rounded up. It will be better understood if you upload a sample file with enough data to check.
    Rgd
    RT
    If my answer(s) helped you, please add me reputation by click on *

+ 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 if cell contains formula
    By brokenbiscuits in forum Excel General
    Replies: 3
    Last Post: 07-26-2014, 01:45 AM
  2. Replies: 8
    Last Post: 11-21-2012, 08:45 PM
  3. Replies: 3
    Last Post: 05-25-2012, 03:30 PM
  4. Conditional Formatting on a cell containing a formula
    By ch1co in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2012, 11:12 AM
  5. Replies: 2
    Last Post: 03-25-2011, 02:15 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