Home |
Search |
Today's Posts |
#1
|
|||
|
|||
color formating ontingenton upon another cell?
Is it possible to have a drop down box (validate, java, something?) that
will highlight an entire row? For instance, If Column A is set for three choices, 1 2 or 3, can i have the corresponding row highlighted a color for each? I'm great with validation drop downs, but i don't know a lot about buttons and such. I believe it would be easier and more user friendly if someone could tell me how using a button or control. Thanks, Jacob |
#2
|
|||
|
|||
Instead of a control, use Conditional Formatting
Select all the cells in the sheet or at least the cells you want to color), with A1 as the active cell. Choose Format Conditional Formatting. In the CF dialog, using the dropdowns and textbox, enter CF1: Formula is =$A1=1 Format1: Click Format and choose a color from the Patterns tab. Click Add. In the second CF block enter CF2: Formula is =$A1=2 Format2: Select a second color Click Add again and enter your third color for $A1=3 In article . net, "jacob farino" wrote: Is it possible to have a drop down box (validate, java, something?) that will highlight an entire row? For instance, If Column A is set for three choices, 1 2 or 3, can i have the corresponding row highlighted a color for each? I'm great with validation drop downs, but i don't know a lot about buttons and such. I believe it would be easier and more user friendly if someone could tell me how using a button or control. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display cell value on a chart. | Charts and Charting in Excel | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
Cell value as chart scale maximum | Charts and Charting in Excel | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |