Results 1 to 2 of 2

Conditional Formatting

Threaded View

clylab Conditional Formatting 02-21-2010, 07:14 AM
teylyn Re: Conditional Formatting 02-21-2010, 07:21 AM
  1. #1
    Registered User
    Join Date
    02-21-2010
    Location
    Scotland, UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Cool Conditional Formatting

    I already have conditional formatting in a cell so that if the cell value is less than a certain number the cell appears RED. The cell containa formula which is linked to other cells. I also want to add another condition which makes the cell appear a different colour should the value in another cell be greater than 0. For example: Cell A1 contains a formula and the conditional formatting means if the value is less than 100 the cell goes RED. If cell B1 contains a figure greater than 0 I want cell A1 to be a different colout, irrespective of it value, I want the 2nd condition ot take priority. How can I do this?
    Last edited by clylab; 02-21-2010 at 07:23 AM. Reason: SOLVED

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1