-
If you would like to post, please check out the MrExcel Message Board FAQ and register here.
If you forgot your password, you can reset your password.
color format
-
O
Color formatting within a formula.
Hello Guys, Need some help on this one. This is my formula =TEXT("3rd (E-L) / ","[Grey]#")&IF(MONTH($A$15)=12,10,5)&"th business day by 5 p.m." This is what it displays = 3rd (E-L) / 5th business day by 5 p.m. This is how i want it to display= 3rd (E-L) / 5th business day by 5 p.m. I want...- omkar94
- Thread
- advanced color format e-l font formatting formula
- Replies: 4
- Forum: Excel Questions
-
S
Cell color based on increasing or decreasing values in a column.
I wonder if some one has a tip on how to solve this conditional type formatting problem. I want to color each cell based on if the value has increased or decreased from the value immediately below. If the value is following a trend the color will get darker, so based on the values of column B...- SyedGangsta
- Thread
- cell colour color format conditional formatting light red
- Replies: 1
- Forum: Excel Questions
-
F
Hide/Unhide rows with specific colour format
Hi there, Wonder if any one can help me with this issue, I have a spreadsheet with data which i need to divide between 3 people. So what I thought I should do is color format every row a different color. ex. Row 1 = Red Row 2 = Yellow Row 3 = Blue Row 4 = Red Row 5 = Yellow Row 6 = Blue etc...- Foxy Lady
- Thread
- color format hide unhide
- Replies: 4
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
VBA to find values in several columns, based on common value in a different column, then copy paste to different sheet
- Started by mlepesant
- Replies: 26
Hello, New to the forum. Good excel skills but almost no VBA experience. I have a file that provides me with Bill of material for different... -
if cell has a value then copy and paste whats in that cell and to the right of it
- Started by drop05
- Replies: 29
Hello, a bit new to this. 1. Using VBA im trying to see if there is a way to check if a cell has a value, in my case cell G52, if it has a value... -
force drop-down list only when 1 of 6 possible answers in a different cell is met.
- Started by CaptainChaos
- Replies: 23
I have done some reading on dependent drop down lists, but everything I have found refers to when there are for example 2 or more choices in 1... -
Transfer table filtered data to new worksheet in respective column, 2nd tab data transferred under last row in respective columns.
- Started by Dave01
- Replies: 23
[URL unfurl="true"]https://www.dropbox.com/scl/fi/4mp0zl1gu1fiizp6dhse6/test-macro.xlsm?dl=0&rlkey=ejd7qgpi7mcg0cfjb6u6qkcdi[/URL] Hi The link... -
Error with Loop
- Started by Jeeremy7
- Replies: 22
Hello, I have a problem with one of the loop I'm trying to do and I think it's in the formula but could somoene help me ? Also I saw that some... -
VBA date in local format
- Started by opislak
- Replies: 21
Hello all, As a European, my keyboard layout is set by default to show dates with '-' as in 11-06-2021 or jun-21 I would like to modify the '-'...
