Backup column
Equal to 5Not equal to 3 (otherwise)Between 3 and 5Not between 1 and 3 (otherwise)Greater than 5
Greater than or equal 2 (otherwise)Less than 5
Less than or equal 10 (otherwise)Formula 1 =$C18=\"a\"Formula 2 =$C19=\"b\"Formula 3 =$C20=\"c\" (otherwise)
5Green highlight6Red highlight3No highlight4Green highlight7Red highlight2No highlight7Green highlight3Red highlight1No highlight4Green highlight8Red highlight12No highlightaGreen highlightbYellow highlightcRed highlightd
No highlight
5634727314812
columnFunction to return color index
InteriorFontTo test the NonConditionalFormatting macro, select cells B2:B21 and run the macro. The conditional formats will be replaced with fixed (regular) formats.To retest, copy the Backup column F2:F21 and paste in the Test column B2:B21Macro works in Excel 97 and later.#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?#NAME?
因篇幅问题不能全部显示，请点此查看更多更全内容