Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Based on Question Mark (*NOT* used aswildcard)
I'm setting up a mostly text matrix (used for tracking tasks and
priorities in a larger project). What I'd like to do is set up Conditional Formatting to highlight any cell which contains a question mark, so that it will be blatantly obvious any time anyone on the team enters a question anywhere in the matrix (whether as "notes" or in a specific field to show that they don't know what to put there). The problem is that in Excel 2007's implementation of Conditional Formatting, the question mark appears to *only* be usable as a wildcard which represents any character, and I cannot find any way to tell Excel that I want to test cell contents for the actual question mark character. I've tried "?" and '?' which only results in matching for the quotation mark(s) with any character between them. Does anyone know how to accomplish this? Is it even possible in Excel 2007? Thanks! |
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 Based on If and Or | Excel Discussion (Misc queries) | |||
using conditional formatting to mark repeated names in list? | Excel Discussion (Misc queries) | |||
Conditional Formatting based on month name | Excel Discussion (Misc queries) |