Posts by Adallia.tyler

Re: Case Sensitive Conditional Formatting

Thanks for your help. I am using 2003, and I tried using the exact fx (as Dave recommended) with the fomulas (that dr recommended) and it did not work. Am I missing a step?

I have recently taken on the task of creating a large protected program (without macros) that automatically updates a PowerPoint presentation. I created corresponding workbooks for each sheet in the original (master) workbook. The corresponding workbooks are then used to paste object into the power point presentation. The only problem is it will not update format (text color) changes into the corresponding workbook. I have solved half the problem with conditional formatting, but I want to conditionally format the color of text to two different colors blue if Aa and Red if all CAPS. Please tell me how to differentiate between Standard word and All CAPS in the conditional formatting.