OK, I have a hyperlink on tab 1 to a form on tab 2. The hyperlink is in red. What I need to know is how can I get the color of the hyperlink to change when just one word has been placed in the form in tab 2???
lets say the range of form input cells in Sheet2 is A1:B10, now define a named range to these cells with a name like "formData"
in sheet one create a hyperlink and format it the way you want. Now go to CF > new rule
add the rule counta(formData)>1 and set formatting as you want (you cannot get rid of the underline though... you have to remove it altogether if you want to...)
