Distinct Colours In A Cell And Conditional Formatting
Feb 8, 2010
This question about conditional formatting appears to be easy. Lets say I have a column like the following, like I posted somewhere else: (not very relevant for this)
BGW
3UG
WWU
1BR
UUBRG
WUBRG
7UUGGRRR
How do I have all characters in this column be coloured accordingly to:
W = WHITE
U = BLUE
B = BLACK
R = RED
G = GREEN
So that 7UUGGRRR would automatically switch to:
7UUGGRRR
What I already tried:
- I applied conditional formatting to the column (actually, the cells interval, [C2..C8]) creating the rule: 'format only cells that contain -> specific text' -> then I added "U" as the text and told it to colour blue. As I predicted, this didn't work; the entire cell containing a single "U" will get blue, which is unwanted.
View 9 Replies
ADVERTISEMENT
May 6, 2014
I'm sure this will be an easy query.
These are marks scored by 5 people in 10 exams
Name of the student
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS[code]....
Range
A1 to K6
In each row top 5 MARKS should be filled with BLUE,VIOLET,YELLOW,RED AND PINK
If its not possible. Top 3 with dark colour, remaining 2 with light colour using conditional formatting
View 1 Replies
View Related
Nov 3, 2008
In a range, say A1:D5, I need to format cells as follows:
1) If cell contains only "H" or "HV": highlight red
2) If cell contains only a number: highlight blue
3) If cell contains a number with the letter "F" ("1 F" or "5.5 F"): highlight pink
View 2 Replies
View Related
Mar 22, 2009
I have ammended the colours to 4 colours that I need for a risk assessment tool . I have added a second worksheet and put a dummy sample of my table there. Can you help me with how to put two colums of conditional formatting in the sheet? The risk rating before and that after the risk treatment? Many thanks in anticipation. I have highlighted in yellow the columns where the product of the consequence and likelihood is likely to be and this is where the colour coding needs to be applied. if you can help with putting the solution in the spread sheet that would be a great help. Any reply via this forum or via my email would be greatly appreciated.
I am new and I hope I have not made a mistake in starting a new thread. Sorry if I have but I wanted to bring this up as a new post so I get a sooner response.
View 9 Replies
View Related
Oct 3, 2012
As far as I can tell Conditional Formatting will not work for this problem.
What I need now is some code to colour the rows in the data sheet ("Standards_Data"), so some other code (which is working fine) can then colour data points on a multiple graphs (which will be on the "Graphs" sheet). I've played around with as much code as I can find but nothing has the flexibility that I need or doesn't seem to work at all.
The idea is that users can adjust the colours using the Column A on the "Graphs" sheet to best highlight certain things. Also this list could then be edited as old Standard ID's become redundant and new ones come on line.
So in a nutshell: Colour rows in "Standard_Data" based on value of Standard ID (Column 4) according to the corresponding colour found in the list in the "Graphs" sheet.
I've attached a trimmed down version of the workbook.
View 4 Replies
View Related
Apr 7, 2013
I normally create charts and use the same formatting for my colours i.e. Gradient fill with Shadow etc...
Now each time i create my charts i am having to keep do the formatting again and again and if i create a new spreadsheet with charts i have to do it all over again
Is there any way i can save this formatting colour so i can quickly apply to my chart series etc?
View 2 Replies
View Related
Mar 20, 2013
Is it possible to change the format of cell AI3 based on the format of cell C3 and D3? I have C3 and D3 set to turn red based on what is in cell C2 and D2. I would like the following done:
If AI3=C3 & C3 is red, format AI3 blue
If AI3=D3 & D3 is red, format AI3 blue
Otherwise, leave AI3 unformatted.
Possible???
View 3 Replies
View Related
Oct 29, 2007
The idea came about after wanting to show a 'gold' 'silver' and 'bronze' background colour, but having to plump for yellow, grey and orange looked a little crap :f
If not, can a workaround be created by using code and a picture or 2?
View 9 Replies
View Related
Jan 8, 2009
A1 is not in any pattern colour. But if A1 is changed into, say, Red, B1 will be equils to D5+F5. Otherwise if A1 is changed into Blue, B1 will be equils to D6+F6. Can it been done by Excel 2003?
View 2 Replies
View Related
Jul 7, 2007
I have a conditional format in Cell J3 that has 2 conditions as follows:
Condition 1: Cell Value, Equal to, ="NO", and then the format will color the cell RED.
Condition 2: Cell Value, Equal to, ="YES", and then the format will color the cell GREEN.
I want Condition 3 to turn the cell J3 YELLOW if there is ANYTHING at all or anything above "0" typed into Cell D3.
View 9 Replies
View Related
Oct 9, 2013
I have two columns. In column B is the date of "last check". I column A is the date of "next check". I would like to have cell A2 in yellow color 334 days after the date entered in cell A3 and than in red color 365 days after the date entered in cell A3. Same thing for cell B2 related to date entered in cell B3. Yellow color in cells announces that check will expire within 30 days and red color that check has been expired.
View 1 Replies
View Related
Apr 12, 2014
I have a formula as follows:- B20 is the cell I wish to format. The formular is =B18-400. My problem is I wish to hide the -400 from the cell until it changes.
View 5 Replies
View Related
May 22, 2014
If the value in column AE falls below 100 it needs to turn yellow. If the value drops below 50 it needs to turn red.
But if the figure in column AB is 0 then i dont want it to do anything at all.
View 2 Replies
View Related
May 29, 2014
how to highlight a particular cell red if the value in one cell is less than or equal to the value in another cell. For instance, How do I make it so that the "Hours to go" cell turns red if the value in the "Actual Last Completion" value is less than or equal to the value of "Last Completed" cell?
View 3 Replies
View Related
Jun 3, 2014
i want to calculate percentage between A and B and highlight top 10 values in B.
as of now i am calculating % in C and applied conditional formatting in C. filtering C based on color i am formatting B manually.
is there any option to avoid this manual work.
Total countAlarm reported%
562545%
783545%
322578%
View 3 Replies
View Related
Jul 29, 2014
In Excel, I want to do conditional formatting on a cell based on the value of another cell. For example: in cell A1, I have text. I want this cell to have a grey background if the value of cell B1 is less than or equal to 1/31/14 and to have no fill (default) if it is greater than that date.
View 8 Replies
View Related
Aug 25, 2014
In the attached, I want cells to be highlighted red if they're NOT EQUAL to 0. Why is this conditional formatting not working (i.e. the cell is being highlighted)?
Conditional Formatting Example.xlsx
View 5 Replies
View Related
Apr 9, 2014
I am working in a table where I would like the whole row to highlight based on the value in one of the cells. These rows of data will be updated regularly, so the formatting has to change with the data.
View 13 Replies
View Related
Aug 21, 2014
This seems way too simple to do yet I can't get it right. It will highlight some that are different and not highlight others that are different. I need to compare column A to O and highlight differences, B to P and highlight difference, and so on.
View 2 Replies
View Related
Oct 3, 2008
Is it possible to use conditional formatting on a cell if it contains comments.
View 2 Replies
View Related
May 19, 2009
I am using the following formula on a conditional formatting to color cell A1 based on cell N5 date =$N5=TODAY()-2
The problem is that I need this formula to consider only weekdays, how can apply formula weekdays to my formula?
View 6 Replies
View Related
Jul 8, 2009
I want to use conditional formatting on a column ('A') to highlight cells that do not have a match with any cells in a specific range.
So I've made a range called 'AcceptedData', which contains a couple of cells with text.
Also included a blank cell in the range, since I do not want blank cells to be highlighted.
Then I used this conditional format forumla on column A.
=COUNTIF(AcceptedData;A1)=0
But it doesn't seem to work. The blank cells get highlighted.
View 13 Replies
View Related
Feb 1, 2010
I have a worksheet with conditional formatting applied. My formula works to change the cell color, font color, and strike-through the font if a "yes" answer is indicated. It all works well EXCEPT that the font color and strike-through ONLY apply to the top line on my cell.
Each cell has a title line, and a few paragraphs in it, with separations between the title line and the paragraphs. I kind of like having the title line a different font, but when it's time to strikethrough I want ALL of the text struck through.
View 9 Replies
View Related
Feb 17, 2010
I want to create a conditional formatting based on a cell in a row. If the value of that cell is greater than or equal to $20 the entire row would be highlighted with a color.
the main thing is that the cells in the rows have if formulas that supple the data for the cells. The cells will be blank if nothing is to be displayed but they will still contain the formula.
View 12 Replies
View Related
Feb 22, 2010
I am working on a spreadsheet in Excel 2007 and i am trying to use a formula in the conditional formatting that will highlight a cell if the date is prior to today's date and the next column over is no. the formula i am using right now is =IF(F2>TODAY(),IF(G2="NO",TRUE,)). the problem i am having is that it is highlighting all cells that have a date and the next column over is no.
i can't figure out how to get it to do an if this, then that function correctly. one other thing that could potentially be causing my problem is that the cells.
I am trying to have highlight are calculated themselves based on a formula. see the attached spreadsheet for information.
View 4 Replies
View Related
Jun 4, 2012
I want to format a cell conditional on the value of another cell. I have read numerous threads on the topic and no matter what I do, it doesn't seem to work for me. I've made it a simple as possible by creating a new workbook and entering:
A1: 5
B1: 2
C1: Some random text - this cell has the conditional formula: ="A1>B1"
However, the cell doesn't get formatted. Here is a screenshot and here is the simple workbook.
View 7 Replies
View Related
Dec 12, 2012
If a cell is smaller than the cell above, I want the cell to be formatted.
View 1 Replies
View Related
Feb 15, 2013
I want to color format a cell based on a percentage value in another cell but I just can't get my head around how to solve it. I've attached a file that explains it better.
E.g.
The formatting for A1 should be something like:
If A2 is
> +/- 10% RED
+/- 6-10% YELLOW
+/- 5% GREEN
Attachment 214464
View 6 Replies
View Related
Apr 22, 2013
I have a spreadsheet of stock data open, high, low, close etc., that streams in real time from thompson reuters. i am trying to conditionally format the G column which is the "(HIGH)" price of the day to alert me when the value of that cell changes price. Basically during the first 15 min of trading my software filters down the top performing stocks of the day. During that time i drag and drop the information in the excel program that is linked to the stock quotes program which might give me up to 30 or 40 stocks. The conditional formatting is to alert me after the 15 min mark if the "(HIGH)" value in that column has changed price to a new high. I can control the stream of the data with a button that turns off the data stream so that it only goes live after 15 min.
photo (1).jpg
View 5 Replies
View Related
Jul 11, 2013
I have a table that has dates starting from A6 which is a whole month say 01/2/2013 to 28/02/2013 like a gantt template.
I need if the word "Ordered" is in B5 I need X (crosses) in the date cells starting from B6 to end of month until someone changes B5 to Delivered then I need the X to disappear.
test.xlsm
[URL] ....
View 2 Replies
View Related
