Excel on Circular References

What is a Circular Reference & why use them? A circular reference is created when you refer to same cell Read More …

Change the row color based on a cell’s value (Excel)

Say, you have a table of your company orders like this: You may want to shade the rows in different Read More …