Conditional Formating in Excel

Posted by littlevahn on Stack Overflow See other posts from Stack Overflow or by littlevahn
Published on 2010-05-12T19:58:50Z Indexed on 2010/05/12 20:04 UTC
Read the original article Hit count: 224

Filed under:

excel

|

formating

|

validation

HI, Im very new to Excel and VBA and was wondering I there is a way I could make conditional formatting on drop down Lists.

I currently have a warning if the user enters something that is not valid (data validation) but I want to change the cell's background color to red if invalid or green if valid.

Again there only options are in a List box.

Any help would be awesome.

Thanks

© Stack Overflow or respective owner

Related posts about excel

Excel error "This workbook contains Excel 4.0 macros or Excel 5.0 modules"

as seen on Super User - Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error, "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to… >>> More
Open excel 2007 excel files and save as 97-2003 formats in VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving… >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
vba access values from excel workbook from another excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Any ideas why this code will not work? Workbooks.Open Filename:="C:\a.xls" Workbooks("a.xls").Activate Worksheets("b").Select Dim OutputArray(10, 10) OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value I'm trying to run a macro in one file (unnamed… >>> More
Excel workbook event order and usage when closing Excel

as seen on Stack Overflow - Search for 'Stack Overflow'
Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving… >>> More

Related posts about formating

PHP text formating: Detecting several symbols in a row

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a kind of strange thing that I really nead for my text formating. Don't ask me please why I did this strange thing! ;-) So, my PHP script replaces all line foldings "\n" with one of the speacial symbol like "|". When I insert text data to database, the PHP script replaces all line foldings… >>> More
PHP text formating: Detectng several symbols in a row

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a kind of strange thing that I really nead for my text formating. Don't ask me please why I did this strange thing! ;-) So, my PHP script replaces all line foldings "\n" with one of the speacial symbol like "|". When I insert text data to database, the PHP script replaces all line foldings… >>> More
C# Grid Cell Formating

as seen on Stack Overflow - Search for 'Stack Overflow'
IS There Any Event In C# Winform For Formating The Last Cell Or Last Row After Complete DataBinding. >>> More
Richtext Box formating help in WPF using c#.net

as seen on Stack Overflow - Search for 'Stack Overflow'
i am making a project for bulk emailing . In this I have added a richtext box . I want users to enter the email message body in it and want to give them the ability to format .Richtext box should be able to make the content bold,italics, underline , align it right left and center , increase font … >>> More
jQuery UI Autocomplete formating help, (I'm new to jQuery)

as seen on Stack Overflow - Search for 'Stack Overflow'
I can't seem to figure out how to add additional functionality to the basic jquery autocomplete. Returning the json data isn't the problem, it's how I am supposed to use the extra json data that confuses me. $(function() { $("#q").autocomplete({ source: "/a_complete.php?sport=<… >>> More