FOB (shipping) Dockers loading bagged cargo. FOB, Free On Board, is a term in international commercial law specifying at what point respective obligations, costs, and risk involved in the delivery of goods shift from the seller to the buyer under the Incoterms 2010 standard published by the International Chamber of Commerce.
Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. For example, you can have a cell appear bold only when the value of the cell is greater than 100.
AFAIK, conditional formatting allows only static format applied based on some condition. I want the format itself to be dynamic. For example, I want to set the color of a cell to be its content (if the cell value is red then use red as the color), without setting a conditional formatting rule per each color. I know that this can be done with a macro, but I don't want to run a macro after each cell change.