color cell based on value

Hopefully there is and easy answer to this. I have formatted cells to show colors based on specific numbers: 1, 2, or 3 = red 4, 5, or 6 = yellow 7, 8, or 9 = green. All working fine. EXCEPT - one of the columns is a SUM of the other columns. And that SUM cell is NOT following my...

I'm finishing up a pedigree database of sorts that I've been working on as a personal project, and I need a way to highlight duplicate values. I know conditional formatting can be used to identify duplicates, but I need each duplicated value to be a different color. The goal: I found a VBA...

So i have a formula which reads like this =IF(((INDEX(RSheet1!A$4:$H$108,MATCH(Sheet1!BL$6,Sheet1!$A$4:$A$156,0),MATCH(Sheet1!B$21,Sheet1!A$4:$H$4,0)))=0,forecast($C$6:$BK$6,$C$21:$BK$21,BL6),((INDEX(Sheet1!A$4:$H$108,MATCH(Sheet1!L$6,Sheet1!A$4:$A$156,0),MATCH(Sheet1!B$21,Sheet1!A$4:$H$4,0)))...

Hi All, Following on from your help in previous threads, I've got a merged spreadsheet! Hooray! :cool: Now I have a (very long) spreadsheet filtered by name. So for example Location----------UserID------First Name--------Surname Manchester--------12345--------Bob--------------Smith...

Hello, I'm trying to change the background color of a cell called Year FL based on the value in it. I can't use conditional formatting because I have more than 3 conditions (Access 2007). I've set the back style to be normal and I'm using VBA code. This is my code: Private Sub...

Every once in a while I get a column that will not filter by color. In my current worksheet, one column will and a different column has that option grayed out. Why is that? :confused: Both columns employ conditional formatting for the colors. XP, XL2007

<TABLE style="WIDTH: 225pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=298 border=0><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD class=xl84 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 47pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15.75pt...

<table style="width: 427px; height: 126px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:3840;width:79pt" width="105"> <col style="mso-width-source:userset;mso-width-alt:2486; width:51pt" span="3" width="68"> </colgroup><tbody><tr...

example: I want a cell to be colored red if it is blank. How do I do this with a formula or macro in VBE??

Hello, I would like to use vb to fill a cell with color when the intersection of multiple ranges matches, all being dates. Example, lookup range A1:B4 and B1:B4 for matches in C1:F1. If A is empty then it would still look to fill the one B date match. http://imgur.com/2cpZD I know I can do...

Good Day Ladies and Gents Please can you help with the following? Requirements: 1) Needs to be VBA as I'm looking to utilise the SumColor UDF and obviously CF won't allow this UDF to work. Note: Actual colours not important for basis of enquiry just use, Red, Blue, Green, i know how to...

I've created a conditional formatting with 3 rules. I need a cell to color fill based on the difference from the cell to the left of it. For example: cell g26 is selected cell value = f26 format YELLOW fill cell value > f26 format GREEN fill cell value < f26 format RED fill. As soon as I...

The titles a bit shaky, sorry if it makes no sense :eeek: Anyway, im trying to write a code (im pretty nood at excel so bare with me here) that when i put 'Y' (as in yes) into column F it fills that whole row with red or orange. thae code im using at the moment seems to have some end if...