Conditional Formatting Help

[Guest]

In cell C4, I want to add conditional formating based on the following
scenario:

If cell A4 = equals value in range IUS Budget Summary'!B5:B82 and
corresponding row cell value in IUS Budget Summary'!M5:m82 is
"Capitalize"..do nothing, but apply conditional formatting if False.

How would I write the formula?

TIA

Jan

 

[JE McGimpsey]

One way:

Name the range 'IUS Budget Summary'!B5:M82, say, "Table"

Then in cell C4, use the dropdowns and inputbox to enter

CF1: Formula is =VLOOKUP(A1,Table,12,FALSE)="Capitalize"
Format1: <patterns>/<color>

 

[Guest]

The conditional formatting formula doesn't work.

In Cell C4 of sheet2, I entered the following conditional formula:

=VLOOKUP(A4,IUSTable,12,FALSE)="Capitalize"

A4 is on sheet2; my IUSTable is range B5:J82 (which is on the IUS Budget
Summary' worksheet).

Any other suggestions?

TIA

 

[JE McGimpsey]

Your original post said that the lookup value was in column M. If it's
in column J instead, you need to change the 12 to 9.