Formatting a spreadsheet row with color

5 pts.
Tags:
Conditional formatting
Spreadsheets
Hello, I would like to know if there is a way to color (shade in) a row when one specific cell has a value in it. For instance if I am entering in data and column I is for refunds, when that I blank I don't want the row to be shaded, but if there is an amount in that column I want that row to be shaded. Any help would be appreciated.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You did not supply the application that you are using, however if you are doing this in Excel, check this site for a step by step on conditional formatting. If that is NOT the application, then leave more details in the discuss section below.
Good Luck!
-Flame
*******************************

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    You forgot one key piece of information. What application are you using?
    66,200 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following