Results 1 to 4 of 4

Condtional Formating for range using IF formula based on cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Condtional Formating for range using IF formula based on cell

    I need help with my conditional formatting.

    I have data from A5 through I56. Columns D,F,and H are the only columns with which the user will enter data. The other columns are eithe labels or calculed cells.

    I am trying to write a conditional formatting formula based below, but yet it doesnt seem to work correctly.

    if looking at row 5, I want:
    =If(D5<>"",1,0)

    and if looking at row 6, I want:
    =if(D6<>"",1,0)

    so on and so worth though the entire range up till row 56.

    And if true, then 'grey' out range A through I with grey fill.

    My try was to try it for the range of A5 through I5 and write =If(D5<>"",1,0) with my format, and then just copy that rule for the entire range.....but the result is incorrect. When I write this rule and place a value in D5, it greys out A5 through F5, not through I5 as requested.

    Sampel worksheet attached. Sheet1 is my tab with data. I also have another tab label INCORRECT OUTPUt and this just shows what happens with my current formula. And I also have a DESIRED OUTPUT to help show what I need.

    Thanks for looking at this with me.
    Attached Files Attached Files
    Last edited by clemsoncooz; 02-07-2012 at 09:23 AM.

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