How to fill colour to cell in excel

Help Forum
, , , ,
1

Hi all,
How to add color to specific cell in excel file, please guide me on this.
test.xlsx (8.9 KB)
Sample file added please check
Sheet1 input file
Sheet2 output file.
Please guide me on this.

2

Hi @lakshmi.mp

Use can use VBA Macros to do this. Below is the Macro code:

Sub ColorNonNumericCells()
    Dim ws As Worksheet
    Dim rng As Range
    Dim cell As Range
    
    ' Define the worksheet and range to check
    Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to your sheet name
    Set rng = ws.UsedRange ' Change this to the specific range you want to check
    
    ' Loop through each cell in the range
    For Each cell In rng
        ' Check if the cell contains a non-numeric value
        If Not IsNumeric(cell.Value) And Not IsEmpty(cell.Value) Then
            ' Color the cell if it's not numeric
            cell.Interior.Color = RGB(0, 255, 0) ' Red color
        End If
    Next cell
End Sub

image
image736Ă—1031 44.6 KB

Text File
ColorSpecific Cell.txt (670 Bytes)

Output:

image
image1642Ă—144 3.92 KB

Hope it helps!!

3

@Parvathy , can we fill cell using write cell activity.
In actual file the headers are different.

4

Hi @lakshmi.mp ,

After reviewing your use case, I created a workflow and successfully implemented it.

So let me explain you about the approach

  1. Read sheet1 into dt
  2. write dt with “Exclude headers property” ticked into Sheet2
    3.Use Linq to get all the celladdress of the cells containing alphabets into a list
  3. Use a for Loop over the cellAddress List and
    • Use format Cell Activity to Fill the Colour

image
image809Ă—1648 53.2 KB

Below is the Worflow for your reference
colourCell_In_Excel.zip (10.4 KB)

Hope it helps you out!

5

Hi @lakshmi.mp

You can’t use Write Cell to Fill colors. How will be the columns names in the original files?

Regards

6

test.xlsx (8.9 KB)
These are the headers and expected output @Parvathy please look into it

7

Hi @lakshmi.mp

The above code will work at any case. Please check the below output:

Output:

image
image1349Ă—130 6.06 KB

Regards

8

@Parvathy , in actual file there is no numeric values in headers, I have added. In that case what to do.

9

What will be there instead of Numeric @lakshmi.mp

Regards

10

@Parvathy ,
image
Like this 37 fields are there. Please check the screenshot…

11

Hi @lakshmi.mp

Do you want to that five column names to be filled with colors.

Regards

12

ya, which are highlighted with green in sample file need to be filled @Parvathy

13

Hi @lakshmi.mp

Check the below text file and check

ColorSpecific Cell.txt (983 Bytes)

Regards

2 Likes
14

Hi @lakshmi.mp ,

Have you tried the approach

given in the above thread?

Let me know if changes has to be made

15

@Parvathy , what should be the argument
image

image
image1215Ă—535 19.9 KB

Please check the below screenshot, the changes done are correct?

16

Hi @lakshmi.mp

You need not add any arguments. If you want to make the code dynamic then you add arguments.

Regards

18

@Parvathy , thanks a lot able to work on this… Thank you for your support

1 Like
19

You’re welcome @lakshmi.mp

I’m happy to assist you.

Happy Automation

1 Like
20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.