|
Here is a VBA code that you can use as a base for a macro that will do eXtendedConditionalFormatting.
Sub XconFormat()
Select Case LCase(ActiveCell.Text)
Case "sale"
ActiveCell.Font.Color = vbRed
ActiveCell.Font.Background = vbYellow
Case "cash"
ActiveCell.Font.Color = vbBlue
ActiveCell.Font.Background = vbGreen
End Select
End Sub
Just add Case "text" clauses as needed.
Yours
Zweiblumen
__________________
Sodomy non sapiens. : I'm buggered if I know
|