T
Tami
I have a conditional format that "asks" if the cell is a formula, use Black
font. If its a manual input number, use Blue font. (With the help of this
website, I range-named "isformula" as =Get.Cell(48,A1) with A1 being
formatted with black font. the spreadsheet is in blue font as the default.
the i applied the conditional format dropdown box: Is formula=isformula....i
hope that's clear)
but of course now "they" want a third format: If the formula is referriing
to an "outside" file (external link), then make it green.
Is this possible?
tami
font. If its a manual input number, use Blue font. (With the help of this
website, I range-named "isformula" as =Get.Cell(48,A1) with A1 being
formatted with black font. the spreadsheet is in blue font as the default.
the i applied the conditional format dropdown box: Is formula=isformula....i
hope that's clear)
but of course now "they" want a third format: If the formula is referriing
to an "outside" file (external link), then make it green.
Is this possible?
tami