Hello…! I want to fill the colour in excel cell according to condition for the multiple rows i have excel sheet with four columns and i want to fill the colour in marks column where i want green colour where marks are greater than 80 and red colour where marks are less than 80, please refer attach…

@Ranjit_Mhetre Sub ColorMarks() Dim ws As Worksheet Dim lastRow As Long Dim i As Long Dim marksColumn As String marksColumn = "D" ' Change this to your marks column if it's different ' Set the worksheet Set ws = ThisWorkbook.Sheets("May") ' Change to your sheet name …

How do you fill a cell with color based on a condition?

Help Studio

Kanak_Lata_Singh (Kanak Lata Singh) July 31, 2024, 9:33am 2

Hi @Ranjit_Mhetre

Please refer below threads , hope it helps .

Topic		Replies	Views
Fill excel cell color according to condition Studio excel , studio	10	3157	February 10, 2021
Colour condition Studio studio , question , activities_panel	2	544	February 28, 2023
To set color to a specific cell in excel based on condition Studio excel , activities , question	5	2526	February 20, 2020
Set Color to that Cell Studio excel , activities , question	12	3053	March 28, 2020
How to make row or column colour in excel Studio studio , question , activities_panel	10	2460	February 26, 2021

How do you fill a cell with color based on a condition?

Related topics