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.
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.