Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Conditional formatting for HYPERLINK formula

I have a Calc spreadsheet with 10 columns formatted as currency with an 11th column averaging the amount of the preceding 10 (=AVERAGE(Ax:Jx)). To some of the cells in these 10 columns I have applied a HYPERLINK formula linking to webpages, reason being that "Insert > Hyperlink" loses the currency formatting and becomes plain text, rendering the cell useless for the AVERAGE. I have defined a style ("Price hyperlink") for these HYPERLINK cells to differentiate them from non-HYPERLINK cells. So far I have been applying the "Price hyperlink" style cell by cell. Is there a way to apply a conditional format (in this case "Price hyperlink") to any cell with the HYPERLINK formula?