-
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
