In MS Project I create a dashboard like column that puts a red, yellow or green icon in the cell depending on the status of the task. Can I do this in Excel. I've tried finding some way to use conditional formatting but no luck. For example.
Col1 = where I want to put the icon
Col2 = has budget estimate
Col3 = has budget used
Make col1 have a red icon if Col3 > Col2