Conditional Formating Based on Formats Instead of Values
Question 1:
Is it possible to have conditional formating based on the format of another
cell instead of the value of another cell? For example, I need A1 to show a
strikethrough, but only if A2 is formatted with a strikethrough. Is this
possible?
Question 2:
Is it possible to copy conditional formatting into other cells while
allowing Excel to logically adjust the formula to the current perameters
(much like copying and pasting a simple formula)?
|