Closed

Excel Spread Sheet Condittiona Formatting

This project was awarded to iainwatson for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$10 - $30 USD
Total Bids
20
Project Description

I have Excel 2003 on Windows 7. Made a bid tabulation sheet for my business but I'm constantly changing the Output Sheet when my bid tabulation sheet changes. I need to make the rows of cells disappear/reappear in output sheet if my bid tab sheet changes (or has not data). Example In My Bid Tab Sheet I may have 10 rows of items for one project and 7 rows in another. The Output Rows in project with 10 rows work but when I use the same template and rework everything for project with 7 rows in bid tab sheet, I have to go to output sheet and change/hide the rows there. I need to make the Rows in the output sheet disappear if there is no data in bid tab sheet row and still keep the formula in that row. I think this is what you call conditional formatting but IM not too sure.

Also I opened my excel file on another computer and Excel crashes every time I view the sheet that has the missing image or image that is supposed to be there but the image file is missing. When I click on the sheet with the image, I can see the path and where the image is supposed to be but with no image and Excel Crashes. I have tried to view the sheet in Excel Safe Mode but problem is still there. I need to change the path or reconfigure the sheet without deleting it

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online