Conditional Formatting Help
 

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

Conditional Formatting Help
 

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

In article ,
Jan wrote:

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

Conditional Formatting Help
 

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" wrote:

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

In article ,
Jan wrote:

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

Conditional Formatting Help
 

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.

In article ,
Jan wrote:

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?