Colour formula for line (shape)

[Fatedela]

Hi,

Is there any way that i can use formula so that when a cell is at certain value, the line (shape) will change color accordingly.
Sry,unable to attach excel doc.

Slide1.PNG

Thanks!!

[Pete_UK]

It would help if you attached a sample Excel workbook. To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

[Fatedela]

Hi,

Sry,i had tried it, but it take forever to load and no response after that..