How to fill cells of certain with a color (Excel)?

Answer Yes, it can be done easily using VBA. What is the range of cells to evaluate? Used range, column(s), row(s), etc?

Top Q&A For: How to fill cells of certain with a color (Excel)

Can you change the color of selected cells in excel 2007?

Go to your System Preferences, and choose "Appearance". The setting in question is not an Excel-level setting; Excel just uses the highlightcolor specified in System Preferences for the "Highlight... Read More »

Anybody tell me how to copy cells automatically in MS excel just by selecting cells by arrow key?

I am not sure why you would want to alter the typical functioning of the arrow keys, it would not be a wise decision. There are many shortcut key combinations of selecting cells within MS-Excel: ... Read More »

Can Excel 2003 display the count of the cells and also sum of the cells together in status bar ?

From what I am aware of, not in the normal everyday way. From version 2003 or earlier, you may only see one of the aggregate values at a time in the Status Bar area, by right-clicking and choosing... Read More »

I want Excel to count how many cells contains "A" and how many "c" are under cells that contain "A"?

one solution could be this:The cells that contain a and c are in column Aexample of data:abcbadbcbcabbdcdaccdbthen in column B , cell b1 insert the formula:=IF(NOT(ISERROR(SEARCH("a";A1)));1;"")and... Read More »