Conditional Formatting with Formulas

[hilton426]

Hello, ExcelForum

I'm trying to use Conditional Formatting to format a row when a tick box (VBA) is not selected.
I've managed it for one row but how can I replicate this down the whole table without creating individual rules for each line?

The TRUE or FALSE in column A is just an ISBLANK formula based on whether there is a name in the Name column.

Help would be hugely appreciated!!
Thank you

[63falcondude]

You don't need the TRUE/FALSE values in column A. First clear your existing rule.

Select B7:C10 (or however far down your data can go) > Conditional Formatting > New Rule > Use a formula

=AND($B7<>"",$G7="")

Format: Fill red > OK > OK

This will give the cells in columns B and C red fill when there is a value in column B and there is not a value in column G (assuming column G is your "Name" column).

[hilton426]

Thank you, 63!!
That's amazing and works absolutely perfectly

[63falcondude]

Thank you, 63!!
That's amazing and works absolutely perfectly

Great! Happy to help.

Thanks for the rep!