conditional format in vba

Hi everyone, I could not find a solution for this. On Sheet 1 I have a table such as this: <colgroup><col><col></colgroup><tbody> Vehicle Car Colour Code Red Bicycle Blue Tricycle Yellow Motorcycle Yellow Train White Plane Green Boat Aqua </tbody> On Sheet 2 I have another...

I have a complex spreadsheet which has a summary report. There are perhaps 200 populated rows on the summary, but for clarity I wish to set row height to hidden or 1 based on what is in the row. For example, in row 45 if cell B = " " I would like that row hidden or compressed. Row 46 may appear...

Hi all, I have a sheet generated by a software every month, so the layout is the same but more or less rows. For this I am writing a code to format it for us as we need it, to make reports from it, so we don't have to format it manually, and I am trying to add some conditional formatting to it...

Hi there, ive tried everyhting on this and cant get it to work!! I have a table where in Column A i have the months January, February etc. and data all along to AJ I want the entire row highlighted or bordered in some way if that row = todays month. I've tried a couple of VBA codes and...

I have an excel file containing values from the Square of Nine and would like to add conditional formatting to include: 1. horizontal line at 180 degree angle 2. Vertical line at 90 degree angle 3. diagonal line at 45 degree angle Can you help formulate a formula that can be enabled as a...

Hello! I'm trying to figure out how to conditional format cells with particular text in the comment section. If the comments say "Ad" then I would like the box to turn red and if the comments say "TPR" then I want it to turn blue, and if the comments say "Both", then it would turn green. I...

I am very inexperienced with VBA (essentially only know to use the record tool and google everything else), but I am trying to create a macro to alternate row colours in a selected range. I am currently using conditional formatting and this is what the code looks like right now Sub...

May I know if it is possible to add this by range? For example, for range($E$5:$E$66), I want each of them to compare with the cell value on the next column (say $E$5 to $F$5....$E$66 to $F$66). I realized I couldn't just do it, so I recorded a Macro and would like to just use a short key on...

Hi guys, I am fairly new to doing VBA coding stuff so if my question seems a bit obvious, that's why. I am trying to do a results table for football like this: <tbody> Team 1 Team 2 Team 3 Team 4 Team 1 2-1 0-3 2-2 Team 2 1-0 1-2 0-0 Team 3 4-1 2-0 2-0 Team 4 2-1...

Hello, I am trying to apply Conditional formatting using VBA from an active cell location. I can't get it working no matter what I do. I think I've narrowed down the problem to the bolded parts. If I have an actual cell address (C19) I can get it to work for a range starting with C19. I...

Hi, I want to use conditional formatting on some cells using the following formula: =ROUND(SUMIF($D$4:$D$85,"New Profit",E$4:E$85),0)<>ROUND(SUMIF($D$4:$D$85,"Profit",E$4:E$85),0) When I record the macro, I don't see anything in the Sub.. Has anyone any idea if this can be done? Thanks, Eoin

I am new to VBA and want to create a macro which will add conditional formating to the columns which I insert. I need each row to be formated the same. I want it set up so that if the row (D4:D29) says borrow it highlights the highest rate. If it says lend it highlights the lowest rate on that...

Hi, I am trying to do conditional formatting within a macro because the range changes each month when I run it... However, it is throwing up a confusing issue...Here is the code Dim T1 As Worksheet, _ Upd As Worksheet Set T1 = Sheets("Table 1") Set Upd = Sheets("Update")...

Hello All, I've got 1 or 2 questions concerning Conditional Formats in Excel 2007. (CF for short in the rest of the post). This is the situation. On one sheet there are a some 10 area's on which I have applied multiple different CF's. Now I'm faced with the issue that by copy pasting, and range...

Hi there, I have a relatively simple project (I have effectively been asked to turn an MS Excel spreadsheet into an MS Project one because...:confused:) sheet 1 named "Schedule" will have various bits of data in In sheet2 named "Graphical" I have the following B1:BMP1, Merged cells showing...