color cell if

I'm trying to combine code that will add/remove a check mark and change the color to yellow when the check mark is added and change it to no fill when removed. I know virtually nothing about VBA code though. I have this code that adds/removes the checkmark fine: Private Sub...

Is it possible to determine an argument if D2 is =< 50% of E2 to color format D2 and or column D?

Hope all is well, This is what i plan on doing, Cell A1 has the word Approved, and cell B1 has a Date, I want excel to do the following If someone enters the word Approved from a drop down in Cell A1 then highlight the cell RED If someone enters any date in cell B1 then cell A1 will have no...

Hi, I am trying to count data from Table 1, in Table 2 - but I need to only CountIF the cell contains the specific text (FRED,GEORGE etc.) AND a specific colour as shown. Table 1 <tbody> *RED* *GREEN* 1:00pm FRED GEORGE 2:00pm DAVE DAVE </tbody> Table 2 <tbody> *RED* *GREEN* FRED...

Hello guys! Really noob VBA and macro user here! I need your help for something I have to do at my work to make it more simple and fast for me. I'll try to explain myself the best I can, sorry if I make this overly complicated, that's not my intention, but I have many variables to consider, so...

Using this simple code to conditionally format cell if "X" is true, can someone share what the most simplistic way is ~ to accomplish this whether it be with NUMERIC or TEXT methods? IF NEEDING TO CONDITIONALLY FORMAT NUMER: (THIS CODE WORKS GREAT BUT IS THERE A SHORTER MORE SIMPLISTIC WAY?)...