conditionally

I have to delete this file But there is a condition Kill "C:\Users\WolfieeeStyle\Desktop\1.xls" Kill "C:\Users\WolfieeeStyle\Desktop\2.xls" Kill "C:\Users\WolfieeeStyle\Desktop\3.xls" If there is kill.xlsb in this path C:\Users\WolfieeeStyle\Desktop then only kill all that files and if it is...

<tbody> RED AMBER GREEN DAILY Yes WEEKLY Yes MONTHLY Yes </tbody> Hi, After some conditional formatting advice please... I have 2 sheets in an excel workbook, the content of sheet 1 is a pull through from a table in sheet 2. I would like to be able to conditionally...

Hello once again all, here is my current problem. I need to be able to conditionally format information in column B based on the conditional formatting of column C. Example: Column B contains several hundred entries and some have the same information but entered differently ("The dog is...

Hello! Is it possible to colour a part of a line in a graph based on the colour of the source cells? Thanks!

Dear ALl, I do have a small sample data set across A1:B10 as follows. I would like to conditionally sum as per the desired result across C2:C10. Could somebody help me out with the formula which can yield the same? <colgroup><col span="2"><col></colgroup><tbody> Region Identifier Desired...

Hi I am trying to work out a way of conditionally formatting individual cells which are determined randomly when a spreadsheet is opened I am using RANDBETWEEN to pick 5 numbers, eg. 3, 5, 18, etc I then want to conditionally format cells C3, C5, C18 Is this possible using formula or do I...

Hey team, I'm currently working to create a "Project Timeline" using conditional formatting. The values I'm using are in Fiscal Quarters (Q1, Q2, Q3, etc). If we have a project starting in Q1 and ending in Q3, I can easily highlight Q1 and Q3 using simple conditional formating, but that leaves...

Hello, I want to conditionally format the highest value in a row. However, I only want to highlight the most recent occurrence of that value. For instance, in the table below, I only want to highlight the 6 that occurred on 4/21/2018, not the one that occurred on 3/31. When I try to write a...

Hello Excel community! I would like to conditionally format a column containing numeric values. For example, columns containing a number between 1-3, I would like to highlight in green. However, there are numbers with decimal places in my column, and Excel does not highlight them. For example -...

People, Please lend a hand. I want B1 and then C1 to conditionally format with a green fill if they equal 90% or more of cell A1. Looking around I thought this formula I found would (for cell B1) do it =(B1/A1)>=0.9 But it didn't format. And I cant figure it. As ever, thanks <tbody> A...

Hi everyone. I have two issues that I think a lot of you would be able to help with. Issue#1: Conditional Formatting I have 3 cells in different location in the same row that need to be conditionally formatted. Each of the three cells already have a formula in them. End state, I want the...

Hi, I have a sheet essentially as follows: <tbody> 1 2 10 6 8 0 12 40 6 Order 1 2 1 12 Order 2 1 Order 3 1 12 5 3 10 Order 4 1 2 6 1 </tbody> I'd like to conditionally format each cell in column A based off if any of the quantities...

Hi All again, I have the following code which I thought will do the job for me. Unfortunately not. Sub Int_Col() With Range("D15:Q101") If Range(cell.Row, "A") = "" And Range(cell.Row, "C") = "" Then Range("D15:Q101").Interior.Color = 192 Else: Range("D15:Q101").Interior.Color = xlNone End If...

Is there a way to match bar graph column color based on the conditionally formatted color of a cell? I'm not too familiar with macros, but I ran one that I found on here that was able to change the column color to the cell fill, but I haven't been able to find one that changes the column color...

just got upgraded from 2003 to 2010! I have about 500 rows of data. In my amount column I need immediately identify the rows that end with .0 and .00. do I have to set up two conditions? If so how?

Hi, I am doing a project with excel and have been watching a lot of videos and reading on the web to be able to do what I am planning to do but have not found a good solution yet. Basically I am creating an interactive dashboard where I am allowing people to choose from the first section one...