Conditional Formatting for Dashboards

[wmcnabb084]

I am building a dashboard that reviews inventory levels. I need to know if there is an easy way to use conditional formatting when using a connecting line from the Shapes Gallery (simple arrow line)? I would like this line to change colour based on inventory levels or conditions.

Thanks Wyatt

 

[Andrew Poulsom]

Welcome to the Board.

Sorry no. Conditional formatting applies to cells not shapes. Maybe you can use this:

http://www.andypope.info/tips/tip011.htm