#conditional formatting

I have a scorecard that has a scoring grid with values 1-5. Each number has a set color. 1 = Red , 2 = Orange , 3 - Yellow, 4 = Light Green, 5 = Green. When a user enters one of those values from the, the cell's color should automatically match that of the grid. Meaning, if I enter a score of 3...

Hi! Newbie here. How do I use conditional formatting to format a cell in a intersecting cell based on a match between a column value and a row value? Something like this:

We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...

Hi guru's. Is it possible to get conditional formatting to insert text in addition to color? Would like to have columns in the Gantt form marked with color and description of public holidays I don't want to insert text or formulas into the gantt form Hope to hear from you guru's soon. Best...

Hi all, I currently have a data set that looks like this: I would like to transpose my information down under columns H-L so that for ALL cells in A that contains "George", their respective cells in columns B-F will be transposed under column H. Likewise the same for all cells that contain...

I have two columns side by side "Follow Up w Pt." and "At-Risk Pt." We would like to be able to either: a) Enter the number 1 to set a Green flag for the Follow Up and a Red flag for the At-Risk or; b) Enter 1 for Follow Up and 2 for At-Risk These discrete values (1 & 2) trigger other workflow...

@ How to Get Period-wise Stock N3 =SUMIFS(E:E,C:C,L3,D:D,M3) ( IN) O3 =SUMIFS(J:J,H:H,L3,I:I,M3) (OUT)

I started using VBA in excel I have a spreadsheet named "MasterReport" 1. this macro will create a new spreadsheet and name it with the value in MasterReport's cell "B2" (OldDatax) 2. the existing data will be copied and transferred to the "oldDatax" sheet everytime I run the macro 3. Fresh...

( i was try to making Auto filter data) "When I paste data into a table, the data should be sorted by invoice number, pleased Share to right way vba to possible Tricks"

Dear all, Happy to join mrexcel ! I have an brain teaser with VBA. I want to create a macro that will color: - Hard coded cells in blue police. - Formula (ex: vlookup): In black police. - Linked cells (ex: =Sheet1!$B$5): In green police. Do you have a code that could work out ...

I Need Hyphen " - " Symbol via Formula, Unique Number based Condition , Found Duplicate & set Hyphen Symbol - in D Coloumn

My Formula Problem this above condition , Not show Proper Format We Need this Format Result : EXP/025/21-22 Kindly Correction Below Formula , and Show Perfect Formula in this case =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I am putting together a tracking spreadsheet whereby we have tasks that need to be done in relation to an end date. For example, a welcome email needs to be sent 3 weeks before the date. If the cell is still blank TWO weeks before and up to the date of, I'd like the cell to be yellow. On or...

@ How to make One Dropdownlist , Including all table Column Cell Details Show ???? without Dependent Dropdownlist ??? How to show dropdownlist using different -different Columns data , And Add Included Single Dropdownlist ************************************************NOT USE DEPENDENT...

How to Match workbook to other workbook data & Get status (HOW To MATCH "BOOK2" WITH "BOOK1" , All data Match , to Get Status and Highlight 4 CELL matching How it possible ???

How to Highlight cell Text After MATCH With Paragraph in Text / Number ???? Make alert Status ??? EXAMPLE : Like Certificate Number & Date Matching With Paragraph Text , I try Match Condition Text With Paragraphy Both Text Are Match : Condition Show is "TRUE" Both Text Are Not...

Hello, I am having issues with conditional formatting and cells. I currently have a document with 630 rows and 19 columns (varying between text and numbers) I am trying to do conditional formatting based off a each individual cell in column 'S' for each row which will conditional format...