| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fill a cell based on another cells value
can i fill a cell with a color based on a value from another cell?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fill a cell based on another cells value
Use Conditional Formatting.
-- Gary''s Student - gsnu201001 "r2rcode" wrote: can i fill a cell with a color based on a value from another cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fill a cell based on another cells value
i looked into that but it all seems to be based on your filling the cell with
the value. i need to fill a cell based on a value from ANOTHER cell. if you know what condition to use, it would be appreciated. thanks. "Gary''s Student" wrote: Use Conditional Formatting. -- Gary''s Student - gsnu201001 "r2rcode" wrote: can i fill a cell with a color based on a value from another cell? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
fill a cell based on another cells value
when you go to the conditional format option.
cell rules more rules use a formula to determine which cells to format don't forget to press apply hope this helps "r2rcode" wrote: i looked into that but it all seems to be based on your filling the cell with the value. i need to fill a cell based on a value from ANOTHER cell. if you know what condition to use, it would be appreciated. thanks. "Gary''s Student" wrote: Use Conditional Formatting. -- Gary''s Student - gsnu201001 "r2rcode" wrote: can i fill a cell with a color based on a value from another cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing cells within a column based on cell fill color | New Users to Excel | |||
| Excel 07 fill in cells based on what is selecte in another cell | Excel Discussion (Misc queries) | |||
| Is there a way to add cells based on their shading / fill colour? | Excel Discussion (Misc queries) | |||
| Fill Cells Based On Cells In Another Sheet | Excel Worksheet Functions | |||
| Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
Linear Mode
