Need to use color as argument excel
Closed
karissao
-
Aug 26, 2009 at 12:01 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 26, 2009 at 07:25 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 26, 2009 at 07:25 AM
Related:
- Need to use color as argument excel
- Number to words in excel - Guide
- Notepad++ change background color - Guide
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
- Rg45 color coding - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 26, 2009 at 07:25 AM
Aug 26, 2009 at 07:25 AM
if the data is from A1 down in column A use this macro. modify the macro to suit you.
Sub test1() Dim rng As Range, c As Range Set rng = Range(Range("A1"), Range("A1").End(xlDown)) For Each c In rng If c.Interior.ColorIndex = 3 Then 'colorindex=3 means red c = 200 Else c = 150 End If Next c End Sub