View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jan Jan is offline
external usenet poster
 
Posts: 159
Default 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