Siddhu11011
Board Regular
- Joined
- Jun 22, 2022
- Messages
- 56
- Office Version
- 365
- Platform
- Windows
I have applied color coding to cell if the condition is true by using conditional formatting.
Selection.FormatConditions.Add Type:=XlExpression Formula:="=ABS($B$11=$L$2)
Selection.FormatConditions(Selection.FormatConditions.count)SetFirstPriority....and so on
Here B11 cell is changing every time. Instead of fix that, I want active cell to be picked up.
Any solutions please
Thanks in advance
Selection.FormatConditions.Add Type:=XlExpression Formula:="=ABS($B$11=$L$2)
Selection.FormatConditions(Selection.FormatConditions.count)SetFirstPriority....and so on
Here B11 cell is changing every time. Instead of fix that, I want active cell to be picked up.
Any solutions please
Thanks in advance