Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditianl formating with AND formula
Hello,
I'm trying to format a column (Range("g1:g7")) based on the value of each row in that column AND the value of the same row in another column Range("g1:g7").Select aa = "EMEA" bb = "South Africa" daformula = "and($g1=aa,$e1=bb)" Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _ Formula1:=daformula Selection.FormatConditions(Selection.FormatConditi ons.Count).SetFirstPriority With Selection.FormatConditions(1).Font .Color = -1638844 .TintAndShade = 0 End With I've tried the above but does not work Any advise? Thanks Avi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula and Formating Help | Excel Discussion (Misc queries) | |||
formula or conditional formating | New Users to Excel | |||
Conditional formating formula | Excel Worksheet Functions | |||
Formula Formating | Excel Worksheet Functions | |||
Formating with a formula | Excel Discussion (Misc queries) |