ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula when formula returns true.
I use this method a lot in my tools and wanted to simplify calling and applying that formatting.
Returns total number of conditional formatting in that range after adding this one.

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Bold.codes

Linkedin Login

AreaRange, MatchFormula1, MarkColor, Optional Shee = "Active", Optional WB = "This"

To mark row of A:L with green when column I has "No", call it as ...
ConditionalFormatting_ColorARow "A:L", "=Indirect(""$I"" & Row(), 0) = ""No"" ",rgb(240, 255, 240),"Sheeet1", "OpenBook.xlsx"

Views 2

Downloads 0

CodeID
DB ID