+ Reply to Thread
Results 1 to 3 of 3

Trying to conditionally format

  1. 03-16-2008, 09:03 PM #1
    Speedbird1
    Speedbird1 is offline
    Registered User
    Join Date
    10-13-2007
    Location
    NW England, Lancashire
    MS-Off Ver
    Office for Mac 2011
    Posts
    42

    Trying to conditionally format

    The attached workbook is just a column of prices, i am trying to seperate out the zero value ones by colour but whenever i click a cell to the formula bar it does not look like it does in the cell i.e GBP does not show. I am really confused. Any help please
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-16-2008, 09:11 PM #2
    Portuga
    Portuga is offline
    Forum Contributor Portuga's Avatar
    Join Date
    02-20-2004
    Location
    Portugal
    MS-Off Ver
    365
    Posts
    852
    Go to conditional format. Select
    "Value of cell" ; "Equals"; type 0 choose any colour
    If you found the solution to your question. Mark the thread as "Solved"
    Thank everyone that helped you with a valid solution by clicking on their

    There is no such thing as a problem, only a temporary lack of a solution
    Reply With QuoteRegister To Reply
  3. 03-16-2008, 10:17 PM #3
    Speedbird1
    Speedbird1 is offline
    Registered User
    Join Date
    10-13-2007
    Location
    NW England, Lancashire
    MS-Off Ver
    Office for Mac 2011
    Posts
    42
    Many thanks Portuga, so simple yet i couldn't get my head around it. i was putting 0.000 as it is in the cells.
    Thanks again
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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