Any Excel gurus here?

kirstiex

I need to create a bar graph which overlaps so you can see the 'target' figure and the 'actual' figure slightly overlapping - I've managed to do this but I've also been asked for the 'actual' value to change to red font when it exceeds the budget value. Can this be done and does anyone know how - using Excel 2003.

Russel245

Nice and easy in Google docs.

I'm sure it is possible, but I've only ever seen it done for positive and negative values.

KrazyKeeper

you need to look into if statements

milesoneill

Do you want the cell text to change colour when its value is above a certain number (Format - Conditional Formatting) or change the value label on a chart when the number is exceeded (not sure how to do this, or if it's possible)?

Miles.

Cash-Strapped.T32

Aren't you getting into macros/VBA territory here?

I've used if-conditionals in basic Excel formulae, but only ever to mess about with numbers tied to certain conditions, not to actually alter cell-formatting..

(stuff like "if Hours => 7.5 then Overtime = True")


I think you will have to look at macros here - Some of the management reports Iuse for work have cells which must be properly populated, so there are macros which scan them, and alter the cell-formatting such that they highlight in red if I have entered the data incorrectly;
So I know it can be done.

Fairwinds

milesoneill wrote: »

Do you want the cell text to change colour when its value is above a certain number (Format - Conditional Formatting) or change the value label on a chart when the number is exceeded (not sure how to do this, or if it's possible)?

Miles.

you need to clarify as above, I think both can be done but one is really easy the other more cpmplex