afternoon

Good afternoon, Nice for for somebody for a Friday afternoon! :-) I know how to use the 56 .ColorIndex values, and how to set an interior or font color to an RGB value, but does anyone know of a quick way to return the RGB value of each element in the Standard Color Palette (Excel 2016) to a...

Afternoon Can someone assist with the correct syntax for the below countif :confused: cell(1,12).formula ="=countif(G1:G100),"<=10000")

https://imgur.com/MW70EzR NOTE: So far, I only have conditional formatting for an X in this sheet and the positions of the "x's" is not valid right now. Please ignore them :) NOTE: Schedule Range E12:BE47 Okay, so what I'm trying to do, is build an afternoon schedule for some of our...

Afternoon Trying hopelessly to format the first 3 cells in Column B Bold then the next 4 cells red so on... Thank You

Good afternoon Is there a way to average a range excluding zero values if any and the highest and lowest value

Hello community, I am stumping over a problem this afternoon. I have the following formula in my Sub: ActiveCell.FormulaR1C1 = _ "=GETPIVOTDATA(""Hours"",'[TestClient.xls]Pivot Table'!R3C1,""Department"",""Client Services"")" I would like to be able to replace TestClient with a string...

Good afternoon, I used to know how to do this but have since lost my knowledge. How do you force a cell to display "" When two other cells are not BOTH filled in for example A1 to display "" if B1 AND B2 are both not filled in

I need to change a range of time (if between 05:00-11:00) into a text (morning) and/or if time is between 11:00-16:00 then it is afternoon and so on. is it a simple if then?