Home » questions » Excel. I need the backcolor of a row to be changed automatically according to the value enter in a g

Excel. I need the backcolor of a row to be changed automatically according to the value enter in a g

2
2006-07-31 14:27:48, Category: Programming & Design
I have a spreedsheet with more than 20 columns and about 2000 rows and i need to change the background color of the row in case a condition is met. For example, if a bill is fully paid I need that row to be orange, or if the bill is void I need that row to be yellow, etc. I know I can do all that using conditional formatting, however that only works for a single cell, right? Why do I need the row to be filled with a specific color? cause that way I know the status of a bill just by looking at it, without revising anything else (I hope I made myself clear, I'm not a native english speaker)

Answers

  1. S S

    On 2006-07-31 14:31:23


    right click

  2. qwertykph

    On 2006-07-31 15:20:11


    You want conditional formatting. But you are not limited to a single cell. In the conditional formatting window, you want to use "Formula is" instead of "Cell value is". Now in order for this to work, you need something on the row to signify the condition. Just choose a cell somewhere on the row, it can be hidden. Let say you choose column AA. Then in column AA, put in values (or build a formula) that shows something like this: 1 = Open Balance 2 = Void 3 = Paid in full Obviously, you don't need the text, only the numbers. Then on the beginning cell of the row you want to change, simple use conditional formatting "Formula is" to point to cell AA1, AA2, AA3 etc. You can copy the formatting from left to right but don't forget to insert $ in formula so it shows $AA$1 !! After copying to right to fill one row, you can copy formatting down to fill subsequent rows. And there you have it! Regards, QwertyKPH