Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
ok... once again i need some help...darn vba got me again...this time what i am looking for is i track certian stats at work such as how long each employee spends on each call and they have a certian goal to get the customer off the phone, well what im looking to do is in excel, when i type in their're stats if its over a certian number i want to the font in that cell to turn red...if anyone knows of a way that i can do this please help

Select your cell or column and then
Go to Format, Conditional Formatting.Set your condition to "Greater than or equal to",click on the Format button and select a color from the 'Color' drop down box for that condition.
Bryan

Bryco's answer sounds like the perfect solution but I'm just curious about something.
You used "vba" in your subject and "darned vba" in your post. Are you looking to do this with VBA or does Conditional Formatting fit the bill?

ok that worked but i got another problem now lol. not im working on a bullitin board for our employees using excel, what a want to do is make it so that if there is a certian word i a cell it will clear the cell, basicly a censor to ensure that there is no profane language... any ideas?

My first thought relates to how many profane words there are and how could you possibly check for every one, including variations (e.g. d*mn, sh!t, etc.). Not sure that that can easily be done.
Actually, my first thought was "Why would anyone use Excel for a bulletin board?" but that's a whole 'nother discussion.
My second (third?) thought was "Hmm, this question has nothing to do with "colors in excel vba".
Anyway, if you right-click on a sheet tab, chose View Code and paste this in, it should prevent any entry that contains dog, cat or bird, including Dog, CAT, or My BiRd iS Loud, etc.
Private Sub Worksheet_Change(ByVal Target As Range)
If _
UCase(Target) Like UCase(("*dog*")) Or _
UCase(Target) Like UCase(("*cat*")) Or _
UCase(Target) Like UCase(("*bird*")) _
Then Target = ""
End Sub

Also when this excel workbook is open i don't want and toolbars open, including the formula bar. how can i do this along with the ctrl+s thing

Please re-ask your toolbar question under a relevant subject line.
Thousands of toolbar experts want to help you but don't even know that you asked the question because they aren't following the "colors in excel vba" thread.

![]() |
![]() |
![]() |

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |