I've got a Google Sheet that I'm trying to write some formulas for - it's basically just a bunch of numbers in columns that I'm trying to do some conditional formatting on (per column).
I want to be able to apply the conditional formatting formulas across every column of the sheet, thus my use of anchors ($) in some of the formulas. Below is what I've got so far, but I know these aren't correct both from the standpoint of the formula itself as well as missing the use of certain functions that would make them completely correct based on the cell contents (or lack thereof). Here are the formulas and their description/requirements.
I would like this (and all the other formulas mentioned here) to apply only to non-empty cells that have a numeric value in them.
I'm pretty sure my use of IF() isn't what I'm supposed to be doing, but it seems to work whenever there are numeric values in all of the cells in the column. I'm not sure which functions I should be using to test for the cell being empty and if that should be wrapped inside or outside of something like ISNUMBER() or whatever.