Conditional formatting doesn't change the value in a cell, merely the format
of the display.
You need an IF formula. The syntax of the IF function, and examples, are
shown in Excel help.
--
David Biddulph

"JenOrr" wrote in message
...
I am trying to set up a sales order, I need to set up a formula that if
they
answer yes, then the qty from one column will be transferred to another
column.

Example if they answer yes to glazing in J10, then F25 will equal B25.