View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Ditch Ditch is offline
external usenet poster
 
Posts: 11
Default Conditional Formatting to differentiate between Input and Calcs

Hi Team,
I want to set up a spreadsheet such that data input displays a black font
but any formula or result from another tab has blue font.
That way users automatically differentiate between input cells & calculated
cells. I've also thought about grey backgrounds for calculated cells- maybe
a bit too heavy?
Any Finance best practice tips or examples would be welcome
Thanks,
Ditch