問題描述
使用多個條件的條件格式 ‑ Excel 2007 (Conditional Formatting using multiple conditions ‑ Excel 2007)
我無法在 Excel 2007 工作簿中為具有名稱的一系列單元格設置條件。我需要突出顯示該範圍內包含以元音開頭或結尾的名稱的單元格。請幫忙！
謝謝！
參考解法
方法 1:
Enter the relevant vowels in a range of cells (one each) and name that range Vowel then select entire worksheet and with “Use a formula to determine which cells to format” set:
=OR(COUNTIF(Vowel,RIGHT(A1,1)),COUNTIF(Vowel,LEFT(A1,1)))
in “Format values where this formula is true:” with formatting of choice and Applies to range reduced to suit.