need help with Conditional Formating

Oh man! Ad-blocking software has been detected! :'(

This website is run by the community, for the community... and it needs advertisements in order to keep running. Blocking our ads means your killing our stats!
Please disable your ad-block, or become a premium member to hide all advertisements and this notice.

if you give a bit more info arroryn, then im sure i could ask my mate at work who is a whizz on excel, unless someone else knows?

i'll get back in about half an hour.

 

as i read it arroryn, you need a few cells/cell to be updated automatically with dynamic variables each day?

but you can't really trust the end user to input them properly?

we don't have any real idea to automate this but if you have an absolute address/reference which the formula would look in then you can hit CTRL-ALT-F9 to refresh all the open excel docs at once, from their respective absolutes.

and maybe you could write a macro to actually input the data from Z into X cell?

not really big on macros though...sorry!

last resort, teach the guy to use excel?!