| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A Boolean expression
Is there a boolean expression that will do this? Cells yellow with an A or not. Thanks Howard Sub CellColLetter() '/ Ctrl + q With Selection If Selection.Interior.ColorIndex < 6 Then Selection.Interior.ColorIndex = 6 Selection = "A" Else Selection.Interior.ColorIndex = xlNone Selection.ClearContents End If End With End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF vs Boolean | Excel Discussion (Misc queries) | |||
| Boolean Misread | Excel Programming | |||
| More on Boolean | New Users to Excel | |||
| SUMIF boolean? | Excel Worksheet Functions | |||
| VBA Boolean | Excel Discussion (Misc queries) | |||
Threaded Mode
