R r2rcode Mar 4, 2010 #3 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.
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.
P pmartglass Mar 4, 2010 #4 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
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