fill a cell based on another cells value
can i fill a cell with a color based on a value from another cell?
|
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? |
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? |
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? |
All times are GMT +1. The time now is 08:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com