| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional formatting? | Excel Worksheet Functions | |||
| Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
