Need some help in Microsoft Excel Guys, with the Colour formula ?

Question

what is the formula to filter based on the colour in the cells, as in how to get a count of cells which are coloured. For eg : Yellow.

Answer 1

Excel 2007 can sort data based on their font/cell color.



OR you could use this small code to get the color index number of each cell & then filter.



-- Press Alt+F11 on your keyboard (VB Editor)

-- Insert - Module

-- Copy & paste this code in that box





Function Col_Indx(Cell As Range)

Col_Indx = Cell.Interior.ColorIndex

End Function



-- Now go check the fx functions - User Defined Functions (Col_Indx)

-- Use the formula to get the index numbers & filter by them.

Answer 2

Help with syntax (retired 8 years ago) Want to change the background color of the cell based upon a value



The user enters Values a or b or c



Background color of cell changes (a=green b=red c=yellow).

Thank you

Answer 3

For conditional formatting, you in many cases does not use an entire IF formulation. purely use a formulation which will the two be actual, or fake. as an occasion, use this to format a cellular if A1 isn't equivalent to "confident": =A1<>"confident"

Answer 4

execel uses vbscript for that .

you can do it from script editor.

but i guess there was also a option to call those commands from cells.