Speaker Color Cell
Speaker Color Cell
 |
 Sprint Palm Pixi P120 Cell Phone with Camera GPS Bluetooth  US $34.95
|
 Motorola i880 Nextel Red Bluetooth Camera Cell Phone US $59.95
|
 MINT VERIZON LG VX9100 ENV2 RED VCAST CAMERA CELL PHONE US $53.27
|
 New In Retail Box Sprint Palm Pixi Pda Cellphone 8 gig memory US $53.78
|
 NEW SAMSUNG A177 GSM ATT PHONE UNLOCKED QWERTY BLACK US $69.95
|
 NEW QUICKFIRE GTX75 ATT 3G PHONE UNLOCKED SILVER US $69.90
|
Excel. I need the backcolor of a row to be changed automatically according to the value enter in a given cell.
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)
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