rule

Hi everyone. I have a table on a sheet that I want to apply to some formatting to. RULE 1 where the B column (or table heading = "VAT quarter") has my VAT quarter end dates in. I want to fill the cell colour based on the month of these in the following way: January = Orange fill April = Yellow...

I am trying to do some conditional formatting based upon 2 conditions. I have a column (S) that contains a number. I have a column (G) that contains a Y or N. I would like to highlight any cells in column G where it contains a "Y" and where column S in the same row contains the number 1. I...

I don't know how to say, so look at the image: https://www.dropbox.com/s/rmejl7f0xif7cmb/excel.png?dl=0 Read the text on image. If skills are selected below with any character (for image i used "x" below "passing"), then cells in table below with the same text have yellow background. So i...

I am working with a large data set (12 columns with 45,000 rows of entries) which is updated each day which in turn auto-updates a dashboard (within the document on another sheet) I have created to analyze this data. Currently, I am using the "remove duplicates" function to delete duplicates...

Could someone please help me to create a VBA script which applies the following three conditional formatting rules? Rule 1 Rule 2 Rule 3

I have in column A various strings, and a rule that highlights certain ones in red. Is there an easy way to get the reference of the first cell that has been highlighted? For example, if the cell on row 53 is highlighted, I want to get "A53" I tried FormatConditions.Count but that only tells...

I use the following conditional formatting rule to highlight any dates older than 120 days: =TODAY()-D2:D11>=120 <a href="https://imgur.com/FaPdt6P"><img src="https://i.imgur.com/FaPdt6P.png" title="source: imgur.com" /></a> How can I modify this formula to have an additional, alternative...

I have a conditional rule in cell I2 if less than 02:00 and want to know how I would apply the rule so it colours the whole row from A2 through to K2 Thank you

Hello everyone, I have a file with projects' staffings. Some of the workers assigned to these projects are temporary employees, some of them are permanent ones and some of them are leads. I would like to create a conditional formatting rule that highlights the permanent, associate leads and...

Hi all! I have come here several times in the past to find excellent help with my spreadsheets but I am thinking that I may be looking for something beyond the scope of Excel. I have been asked to take over my department scheduling and I am looking for a solution that will replace the current...

I've created formulas for my conditional formatting, and it works in the first sheet. I've then used the format painter to apply the Conditional Formatting to another sheet - and it's turned my whole sheet green! The rule is not being followed - any ideas?

Hi All! I need to translate the following data validation rules to VBA: Rule 1: Cell does not contain: no blanks format - as white -- stop as true Rule 2: =OR($J3="Pending - Please Elaborate in Notes") as red Both of these formatting rules apply to $K2 through $K1048576 I am...

Hello all, I was wondering how I can go about highlighting a cell (i.e. B2) if another cell in its row (i.e. O2) contains text. I don't want a rule that says specific word or words must be entered, just if the cell contains ANY text. I also then want to copy that rule all the way down the...

Hello, I need help on a multiple expiration date in a single cell.I have these conditional formatting formula in place but for some reason it isn’tworking when there a multiple date in a single cell. Red Rule Type Use a formula to determine which cells to format =OR(...

Hello, is there anyone that would know how to setup a conditional formatting rule to bold any number that is in column A if it's appearing in column R?

I've searched the board and can't quite get the answer I need. If I have a cell that is set to Yellow fill based on a Conditional Formatting rule for that column, I want to be able to set a Conditional Formatting rule for corresponding cells in columns D and F so they also would be Yellow...

Hi there, I am looking to incorporate the below rule as a conditional format rule - use a formula to determine which cells to format. =IF(M2="","",IF(LEN(M2)>12,"Issue","OK")) Do I need to create two rules essentially to replicate this here? Or how do I amend this rule to "Format values...

I would like to know how I can create rule to highlight when column A - b > 50, and <-50 <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> <tbody> Column A column B 300 350 200 201 150 50 </tbody> </tbody> I tried this, but it did not work...

Hi, Trying to colour a cell on one sheet if the reference number entered already appears on another sheet. Googled various options as it keeps filling the cell above instead... The rule I tried is =MATCH($A2,'DNA No Support & WD Pre Census'!A:A,0) Thanks.

I would like help with a formula or rule. I am not great with code. If I enter a date in cell a1 and it is between January 1 - March 31, in cell b1, I want it to say January 1. If I enter a date in cell a1 and it is between April 1 - June 30, in cell b1, I want it to say April 1. If I enter a...