colour

Hi I am looking to format my worksheet with different colours based on a data validation drop down list. I currently can get the drop down cell to be the correct colour but would like the whole worksheet (Columns B-J, Rows 2-67) to be different colours. Any help will be greatly appreciated...

Hi, I want to change 4-5 cells black if one of the cells contains the work remitted and if that cell is blank change it red. Can anyone help I have tried various ways and can only make the cell with remitted change colour.. Thanks :-0 Toni

Hello, I have applied conditional formatting to a range ofcells, for example A1 to D1 and the cells are colour coded based on the value. I am now struggling as the cells in A2 to D2 need to be formattedin the same colour, is there a way to Link the colour format ? SO effectively A1 and A2 would...

Hi, Possible to use conditional formatting to 'sum count' font colour? 1 2 The ans should be 2 'count'

Hi my conditional format is not working and i can't figure out why. i think i have looked at this too much lol. my conditional format formula is: =OR($B18>””,$B18>0) the cell range it is applied to is: =$B$16,$D$16,$F$16,$H$16,$J$16 B18 only ever has a date entered into it if that helps, i was...

Hi I am after a formula that works please If I have A and B. When a date is entered into A1 I want B1 to turn red. When a date is then entered into B1 I want both to turn green. Thanks

Hello I have a sheet but in struggling to see if I'm on the correct row when im filling it in Can you change the row colour when a cell is selected? ie: if I select any thing between G21:AE21 I can get A21:E21 to change colour But if nothing is selected then don't change anything Hope ive...

Hi I've been trying for a couple of hours to conditional colour format cells based on cell value but can't get it right. I have the formulas but I only seem to be able to enter 1 formula but I need to enter 3? My rules are: If B7=>99 but less than 99.9 then shade amber If B7<99 then shade red...

Using Excel 2000 Hi, I need VBA, which can do the following task... 1-Column C:D rows highlight in the colour "Light Pink", in the case if finds any same or reversal patterns in the Columns E:F, G:H, I:J, K:L, M:N or O:P same row. 2-Highlight 3 patterns, which can be the same and can be...

I'm writing some code where each result needs the colour changing and the border setting. The colour is fine as it's only 1 extra line of code however the border is a few. With rng.Borders .LineStyle = xlContinuous .Color = vbRed .Weight = xlThin End With Is there a...

I want to change the colour of the row to green when my 'project status' is inputted at 100%. Is there a way I can do this?

Hello all I have a database with over 300 rows of data. Data is populated through columns A:X Is there a way to filter the rows so that only the rows highlighted a certain colour are filtered? thanks in advance

Hi I have the formula below where I am trying to count how many cells have a colour and counting, where my range is to a and the cell colour is yellow which is p1, but the code doesn't work I get a #NAME ? please can u help? =ASAPCOUNTBYCELLCOLOR(A:A,P1)

hi all nice and easy one for you.. I need a cell with a date entered to fill with a colour when that date is reached and remain that colour until a new date is entered into that cell. all help appreciated

Hello Mr Excel gurus, As the title says, I'm trying to make a simple macro to apply to a button, so I can update the footer details of a Worksheet. I can accomplish all of these steps individually, however when I manipulate the "font colour" property, I can't seem to get things to work with...

Hello everyone, I have some troubles with conditional formatting, see example below: <tbody> A B C D 1 Date 25-Aug-2019 26-Aug-2019 27-Aug-2019 2 activity1 8 3 activity2 8 4 activity3 8 </tbody> My goal is to change the colour of the "activity" cell when: "B2 to D2 is...

I have worksheet A2:L50 which gets updated regular. When I insert ‘Yes’ in cell k2, I would like the ‘whole row (a2:l2) to fill colour to light blue. Would some kind person be able to help & sort for me? MTIA Trevor3007 :cool:

Hi, formula question for Excel 2010 I would like to have 4 cells change colour, if text taken from a range of cells appears within those 4 cells. cells I want to change colour G4 to J4 cells that contain different text options B54 to B75 Example. If I write the text from Cell B60 into...

Hi All I am not sure if this is possible, but I thought I would ask the question in case. I am using Excel for Mac 2016 and have created a Drop Down list. As we scroll down the list - the entry is highlighted in royal blue, but I have been asked if I can change this to our specific green...

Hi folks, I'm trying to write a macro to allow users to change the colour of a selected tab on a protected worksheet. My plan: • Use an input box to get the tab name from the user and assign it to a variable • Present the user with the colour palette to select the colour (standard or custom) and...