Thank you for explaining the difference, as I did not know. When you make a conditional formatting rule, does it write something in VBA?
No, Conditional Formatting does not write to VBA. It has nothing to do with VBA, it is a built-in Excel feature, like sorting, formatting, etc.
Note that you can write VBA code that creates Conditional Formatting rules.
Also, what exactly does the ISNUMBER function do? I have not used that previously. Thanks.
As you might have guessed, it checks to see whether a cell contains a valid number (like all the "IS" functions, it returns a boolean value of TRUE or FALSE).
Note that it not only checks to see if the number is numeric, but also that is was added as number.
If you enter a number as text, it will return FALSE (i.e. if you type a single quote mark before your entry, it will enter it as text).
Note that most valid-entered numbers are right-justified, while most text entries are left-justified (unless you manually change the justification).
Also note that Microsoft/Excel has pretty good documentation on all their functions.
You can find it with a simple Google Search (i.e. "Excel ISNUMBER function").
Use IS functions like ISERROR or ISERR to see if an error condition exists, ISBLANK to check if cells are empty, or ISNUMBER to check if values are numbers.
support.microsoft.com