View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Abby Dabby Doo Abby Dabby Doo is offline
external usenet poster
 
Posts: 1
Default 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)?