Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formating Macro Formula
Hi there
I have this conditional format that highlights items that have a value of a 1000 Columns("A:R").Select Selection.FormatConditions.Delete Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _ "=UPPER($C1)=""1000""" Selection.FormatConditions(1).Interior.ColorIndex = 38 I want to keep this syntax but instead of highlighting items that are a 1000, I want it to hightlight items between values 10000 and 19999 i.e. If the cell contained 12564, it would then do the highlight Does anyone know how to ammend this? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating with IF and AND formula | Excel Discussion (Misc queries) | |||
formula or conditional formating | New Users to Excel | |||
Conditional formating or Macro code | Excel Discussion (Misc queries) | |||
Conditional Formating and Formula | Excel Discussion (Misc queries) | |||
Formula for Conditional Formating - Help! | Excel Worksheet Functions |