conditional formatting is not something i do with every worksheet, only if i want to visually see a set of data in a table without searching the entire table
for example i color code my inventory based on various criteria. example follows.
when you attempt to edit the formula, say add/change criteria(condition), you cannot scroll thru the formula using arrow keys. doing so inserts a cell(s) referance info.
also when completed and you actually test the condition(s) it would be advantageous to get a printout,should anything get erased or modified--handy goto referance
=OR(IF($B2="Verified",1),IF($B2="Located",1),IF($B2="kit cover #",1),IF($B2="*part of KIT",1),IF($B2="xfer shelf bin",1))
specifically I am asking : when i edit formula in the conditioal format dialog, you cannot see the entire formula, so i want to know how to 'navigate' thru the formula to make changes ... arrow keys will not work, yes i can copy/edit in another cell/paste back ... but you will have to exit/reopen dialog...is there a way to navigate thru the formula other then using arrow keys.
(the 'code' i presented was to show how long the text string can be VS size of the dialog window to enter the string itself)
2nd question was how to printout all you conditioal format 'code' for keeping as a referance