green

Hi, I have cell's A though to L. I am wanting the cells filled red unless all the cells have either a value or text in them. All the cells would then change to green. If 1 cell is blank then all cells are red. If all cells have something in them then they all turn green. Thanks in advance

I have five columns (years) and I want to format the highest number colour green and to check the five columns if any is over 400, colour code the first column orange (ignore the green) Thanks in advance.

Hey guys, I'm totally new to Power BI and currently stucked with my work... For you it might only take a few minutes, but for me it would mean a forune! What I would like, to have a slicer that starts from "Service Created". So I only see the Services that has been created before the chosen...

Two date columns. A & B. I want the column B to fill red if the date in column A is greater than 4 days. I want the column to turn green if if the date is less than 4 days. Help please :)

Hi guys - hopefully another easy Conditional Formatting issue. In my workbook, if cell J2 contains YES, I want E2 and F2 to be highlighted Green and so on throughout the sheet on a row by row basis. I have a rule in conditional formatting corresponding to E2 and F2. Formula: = $J2="YES"...

Hi All, Hi All, I need a formula to calculate the following in column D (example of returned info in there): Only bring across the cost (Col C) info from Red (Col A) that is more than £5.00, all others show 0 inc Red, Blue and Green. I need it for a summary at the bottom (if possible) or...

Hi I am trying to make a Macro, whereby I hit Ctrl Shift G and my text or number will turn green. My macro is below: ------- ' Keyboard Shortcut: Ctrl+Shift+J ' With Selection.Font .ColorIndex = 4 End With End Sub ------ It does not seem to work however? Nothing...

I have a spreadsheet that has multiple tabs. Each week I run a report and place it on the "CURRENT" tab and manually change some cells in col b based on the name listed: highlighted yellow, green font or red font. There are also cells that are highlighted yellow and the font can be either...

Hell o, As the Conditional format shows icons for arrows, but the Red points down and the Green points up, is there a code that can change the arrows, so that the Red points up and the Green points down? i have searched and am not able to find anything suitable Many thanks Pugg

Are there any sale dashboard templates people use that they could share? Particularly interested in Speedometer Radial type graphs. I.e green is good, yellow ok and red is bad.

I have a long list of names that I need to arrange. I need to first create a distinct list that is not case-sensitive into a different worksheet in a workbook and to have a unique identifier added to the list of names. Then, I want the identifier and the name attached to that identifier to be...

I am calculating % movements between sets of numbers usingthis formula: =IFERROR(IF(ABS((B1-C1)/C1)>5,””,(B1-C1)/C1),”-“) I now need to add conditional formatting to the formula (orsomewhere) that will apply different formatting depending on which range ofcells and the result: Turnover Range...

In worksheet I have drop down YES/NO in column P If P is "Yes", I want Q:U to be all filled with say colour red If if P is "NO" then no conditional formatting applies But also if Q has a "Yes", the everything P:U turns Yellow And if Q is a "NO", then P:U is Green Could you please assist...

Hello guys ! I try to find a way to remove "#" if the next character is alphabetic and do nothing if it's a "number". For example : #Blue = Blue #5 Green = #5 Green I came up with something but it has no effect : For i = 2 To 300 If Mid(Cells(i, 8), 2) = "[a-zA-Z]*" Then Cells(i, 8) =...

Hi Friends, just researched a lot regarding the below issue not getting it resolved , Could you please review and share the outcome please. in the below scenario just need Column G whenever only $20.00 appears it should be no color except this all will be in green whether its $20.0 , 20 ...

I'm trying to carry over numbers after the decimal point (column in green) and add them to the row belowAt the moment, the RED items are being calculated in each row, and the total is show in BLUE. The number in BLUE is then divided by 7.5 and show in GREEN. A. 47.50 47.50 47.00 47.00 189.00...

I have a 4 step flow chart to follow to put the correct item in the cell dependent on what' in previous cells. Is it possible for me to use a, long, IF statement? The flow chart will never change so I'd only need to do it once! The flow chart is Is it A or B If A, is it 1 or 2. If B, is it 3...

Hi All, I look for older posts,but could not find the solution to my problem. I have a cell that needs to turn Green or Red based on a Target. The target is 65.7%. My cell that has conditional formatting, should be green because It hit the target of 65.7%, but it turns red. my conditional...

Hello, I am struggling to do conditional formatting for a row. It has several percentages from 0% to infinity. I want everything below 100% to be red and everything 100% or above to be green. There are some cells with dashes when the percentage is not available. Any idea please?

Please HELP...I am using a combobox to make a NUMBER selection and linking it to cell z8. When I do, I get the green error mark in the upper left corner, because it's in TEXT FORMAT. I can click on the green error and select, "Convert to Number." But when I make another selection in the...