ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting Borders (https://www.excelbanter.com/excel-discussion-misc-queries/218337-conditional-formatting-borders.html)

AJ

Conditional Formatting Borders
 
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.


Dave Curtis[_2_]

Conditional Formatting Borders
 
Hi,

I'm sure this can only be done by using VBA.

Dave

"AJ" wrote:

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.


Jim Cone[_2_]

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.



All times are GMT +1. The time now is 02:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com