Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format Query
Hi...
I've just written 1000 questions for a user to select from. Having just written them I don't seem to be able to apply conditional formatting to them. Basically, if any line within the worksheet contains a YES, the line on which it is located will go Bold Red font? Is this poss. I did try highlighting the entire lot but it seemed to offset the formula and wouldn't work. Thanks in advance Gordon... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format Query
Highlight all the cells and use a CF formula of
=$H2="Yes" assuming that the Yes is in column H and row 2 is the first selected. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gordon" wrote in message ... Hi... I've just written 1000 questions for a user to select from. Having just written them I don't seem to be able to apply conditional formatting to them. Basically, if any line within the worksheet contains a YES, the line on which it is located will go Bold Red font? Is this poss. I did try highlighting the entire lot but it seemed to offset the formula and wouldn't work. Thanks in advance Gordon... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format Query
If you post what you actually used in the CF criteria we won't have to guess
what might be wrong. That being said, you might try this approach: With The questions in cells A2:A1000 Col_B contains the Yes/No values Select the range to be impacted by the Conditional Format, with the active cell in Row_2. From the Excel main menu: <format<conditional formatting Click the dropdown in Condition_1 and use: Formula is: =($B2="yes") Click the [Format] button and set the format Click the [OK] buttons to finish Does that help? *********** Regards, Ron XL2002, WinXP "Gordon" wrote: Hi... I've just written 1000 questions for a user to select from. Having just written them I don't seem to be able to apply conditional formatting to them. Basically, if any line within the worksheet contains a YES, the line on which it is located will go Bold Red font? Is this poss. I did try highlighting the entire lot but it seemed to offset the formula and wouldn't work. Thanks in advance Gordon... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
conditional sum query | Excel Worksheet Functions | |||
Conditional Format Rank query | Excel Discussion (Misc queries) | |||
Conditional Query | Excel Discussion (Misc queries) | |||
Keep format after paste from other worksheets - conditional format or EnableControl solution doesn't work | Excel Programming |