Results 1 to 5 of 5

Thread: Help with conditional formatting

  1. #1

    Help with conditional formatting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi I am trying to use the greater than or equal to function to highlight a cell when that value is greater than or equal to another cell. For some reason though it highlights the column I have applied the formatting to unless there is actually a lower value does it not highlight the cell. I have several empty cells although formulas are written in them I would assume that when they are blank that the cell would not be highlighted

  2. #2
    Hi MarcusCoates

    Use the AND function. For the example below in the conditional formatting

    =AND($A1<>"",$D$1>=$A1)

  3. #3
    Do I enter that into the conditional format bar?

  4. #4
    Hi

    If you are using Excel 2007>. Select the cells,column/s, row/s where you need to apply the conditions. Then on the home tab. Conditional formatting > New rule > Use a formula to determine which cells to format > place your formula in the Format values where this formula is true > format as required.


    Click image for larger version. 

Name:	CF dialogue box.PNG 
Views:	16 
Size:	33.0 KB 
ID:	1094
    Last edited by Kev@Radstock; 2013-01-27 at 02:19 PM.

  5. #5
    Thanks that has worked but why does doing the simple greater or equal formula not work?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •