Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Conditional Formatting

6 replies [Last post]
Robert Hughes
User offline. Last seen 4 years 29 weeks ago. Offline
Joined: 20 Oct 2006
Posts: 32
Groups: None

Hi,

I was looking for some advise on Asta powerProject (v11).

Is it possible to setup conditional formatting on the spreadsheet like you can within excel? I have had a good look and I can't find a simple solution, more than likely it is staring me in the face but at the moment i am stuck. Does anyone know if/how this would be possible?

 

Many Thanks.

Replies

Rafael Davila
User offline. Last seen 28 min 59 sec ago. Offline
Joined: 1 Mar 2004
Posts: 4993

Robert,

I do not use Asta but consider it a great product. The following shows my ideas, the separate columns with only one range signal I got it by defining unwanted ranges color to be "none", prehaps you have this option. As you can see in this way the column title let you know what the signal means if you use the name for these purposes.

Photobucket

Mike,

The option you mention is not conditional but looks worth looking at if you have Asta, seems interesting to me.

Best regards,

Rafael

Mike Testro
User offline. Last seen 13 weeks 5 days ago. Offline
Joined: 14 Dec 2005
Posts: 4407

Hi Robert

Sometning I have never used is the Priority colours in Tools > Options > Spreadsheet.

That may be worth investigating.

Best regards

Mike Testro

Robert Hughes
User offline. Last seen 4 years 29 weeks ago. Offline
Joined: 20 Oct 2006
Posts: 32
Groups: None

Rafael,

Thanks for your input, i understand your meaning but unfortunately Asta PowerProject (as far as i am aware) only allows the colour change on a small round priority indicator's, which I find is usually overshadowed by the overall colour of the Gantt Chart.

I have gone a different way with this now, exporting all the data into an excel schedule with conditionl formats setup on the columns of importance to highlight late and early key dates. As a regular user of planning software I can extract the infomation I want form a programme quickly and easily however i think others may not be able to do the same, so an excel schedule containing just the relevent info would seem to make more sense.

Thankyou for your comments anyway.

Rafael Davila
User offline. Last seen 28 min 59 sec ago. Offline
Joined: 1 Mar 2004
Posts: 4993

Maybe you can create a signal of whatever color to highlight missed dates only and no signal at all if not, then color won't matter.

If you want to highlight the difference for those missed by certain amount and for those missed by more, maybe your software allows to change the signal graphic as to differentiate one from the other, again color won't matter.

You can even have a signal definition for one range shown in a separate column from the signal for the first range, again color won't matter.

Still I prefer the use of filtered reports and views rather than looking for subtle difference in colors among thousands of activities. We find signals and colors rather limited and confusing. My software provides for these and can even define Gantt Bar colors using a selected signal but we never use it.

Robert Hughes
User offline. Last seen 4 years 29 weeks ago. Offline
Joined: 20 Oct 2006
Posts: 32
Groups: None

Hi Mike,

Thanks for your response.

Using Excel you can setup formatting on a cell which is conditional to the data contained within the cell, for example excel can automatically format the text in a cell blue if the value is less than a specified value, or less than a value in another specified cell. I was hoping to be able to do similar within Asta as part of a procurement schedule, so any missed dates would be formatted red bold for example.

At the moment i have solved it using the traffic light priority indicators however from a presentation perspective i think if the whole title was formatted red it would be clear to the reader which items are overdue or nearing overdue as i find the priority indicators do not print out very well.

Mike Testro
User offline. Last seen 13 weeks 5 days ago. Offline
Joined: 14 Dec 2005
Posts: 4407

Hi Robert

I need to know a bit more abour what you mean by conditional formatting.

You can format all or any cell by using the Format Cell dialogue.

Best regards

Mike Testro