change cell color

Is there a way to change a cell color and add text to a specific cell if condition is True? Ex. I have cell A1 that contains values of either True or False. If A1 is True, I want B1 to change to black and Display "Pass" in white font with the text size of 20. I was wondering if this is...

Hi Everyone! (Sorry this is so dense) I am trying to find a way to use conditional formatting to override my existing conditional formatting, while still retaining it underneath. I want to do this by having the conditional format recognize when I have input a date manually VS. our...

Ok so I'm completely new to excel (and coding in general) and I just can't get it to work. I managed to get this far, but it telly me an End If is missing. (And I'm sure a lot more is missing as well): Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If...

I usually work on it until I solve it... googling the heck out of it. But it's been days with this one and I can't just figure out what I am doing wrong. I simply need to change the color cell... if the value of an adjacent cell falls between certain range. (I CANT USE Conditional Formatting...

Hello all, Does anyone know how to automate changing the color of a chart bar or pie piece when the data changes? Ideally, I would like to put an RGB color code into a cell, then have the chart bar or pie change color based on that code. So if sales of product A is = 20% of goal, I can have...

Hi all, Actually i m a bit confused about this that we can do this or not in excel? So i like i want to do a task which highlight the cells whenever condition is full filled. like consider an example of expiry date:- task is highlight all the cells 2 months before the expiry date with red...

I'm trying to create a teaching resource for use in the classroom. Basically I want to click on a cell and for that cell to change colour, click it again and it changes back to the first colour (almost like an undo) Any help would be appreciated, my knowledge of coding is fairly basic...

Hi all, please bare with me as my first time posting, I am a novice at excel and VB but know the basics, any help is much appreciated. What I am after is a macro, which once played, will check if the values entered in cell (A1) on the active worksheet (Sheet1), are contained in column...

I want to click on a cell and have the color change. There is a cell range I want this to be in and not the whole work sheet. I have some code which was given to me but doesn't include a range. and I want a different color but having a hard time finding the color codes. If I could have...