collington

Coolhands: was hoping to avoid a macro, but will do if that's the only choice. Minimoo: it started life as 'design report' when I was building it but I have saved it until I can crack this nut.

Hey folks, I feel like I've been searching for hours for what must be the simplest thing ever. I have a very simple excel report but when I run it I would like Excel to conditionally format the results. I've tried everything I can think of to create or edit a template with the formatting already in place for the various columns, but either it spits it out as plain data, or it shows me my template with no data in it. Can anyone point me to the 'so absurdly basic we can't believe you're even a SIMS user' excel template guide? Thank you so much for any signposting! Lisa