View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default Conditional Formatting Borders


Conditional formatting can only color the top, bottom, left or right
borders of a cell. xl2007 may be different (better or worse).
Furthermore, only xlHairline and xlThin weights can be applied.
--
Jim Cone
Portland, Oregon USA


"AJ"
wrote in message
Is there anyway to set up a conditional format for a diagaonal line in a
cell? I want the diagonal under a set condition and not the rest of the time.
Thanks in advance for any help.