Conditional Fomatting - Not working for all cells

  • Hi All,


    I'm trying to achieve the following:


    When value in column AG = FALSE, highlight entire corresponding row bright orange.
    When value in column AG = TRUE, remove corresponding highlight from row


    The easiest way to achieve this I think would be to use conditional formatting (using excel 2003)


    My issue is that when false is entered into AG3 for example, all of row 3 is highlighted except for the cells which have text in it. I can't work out how to make sure the entire row is highlighted including text?


    The formula I'm using is: =$3:$23="FALSE"


    Can anyone help? See attachment for an example of my issue


    Thanks.


    forum.ozgrid.com/index.php?attachment/56270/

  • Re: Conditional Fomatting - Not working for all cells


    =$ag3=false then apply it to range of =$A$3:$AG$23


    This is in 2010 so not sure if it is a conflict with 2003...
    That will apply the color only to cells in AG that are false.


    That what you're looking for?
    Hope it helps.

  • Re: Conditional Fomatting - Not working for all cells


    Need to make one addition... your conditional format is based on cell value
    Mine is by formula. If that is an option in 2003 shouldn't be a problem. Not sure if that matters.
    Good luck.

  • Re: Conditional Fomatting - Not working for all cells


    Unfortunately your suggestion doesn't change the result i'm getting Rowddawg, thanks anyways.

  • Re: Conditional Fomatting - Not working for all cells


    Wonder if it's an adjustment to 2003 then... it worked in the dummy sheet I downloaded from you. Sorry that I'm not more knowledgeable on 2003. I'll try to look up some stuff later in the day if no one else has responded.


    Thanks.

  • Re: Conditional Fomatting - Not working for all cells


    This formula works for me


    =$AG3=FALSE


    Ediot: Tested in Excel 2003 & 2013

  • Re: Conditional Fomatting - Not working for all cells


    Hi asdfdsafdsf
    Are you entering the formula as Rowddawg and Roy said? That is without quote marks on FALSE.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!