Formula with dates in COLOR

L

loulou

On August 21, I submit a question regarding formulas with dates. Now I need
to color each one of the codes that I obtained with the formula.
My results of this problem :
M-00
M-01
M-02
M-03
M-04
M-05

etc.....

I need that each one have a color but for all the row that contains that
code in certain columns.

Thanks
Loulou

LAST QUESTION AND ANSER REGARDING THE SAME PROBLEM:

Assuming your dates are in A2 and onward, in B2:
="M"&TEXT(MONTH(TODAY())-MONTH(A2)+(YEAR(TODAY())-YEAR(A2))*12,"+00;-00;-00")

This will detect how far each month is away from today's date, and format it
match your coding standards.
 
L

Luke M

Hello again loulou,

How exactly do you want the codes colored? Does each code need its own
unique color identifier? Assuming a basic structure where negative values
need to be red, and positive values are green...

Select the entire row you want formatted. Goto Format - Conditional
Formatting.
Change first dropdown to "fomrula is". Input the following:
=MID($A2,2,1)="-"
Click the format button, go to pattern, choose red. Out.
Add a condition.
Formula is:
=MID($A2,2,1)="+"
Click the format button, go to pattern, choose red. Out.

Hit Ok.
(Note that I am assuming the date codes are in column A. Change letter as
appropriate).

If this is not what you were looking, or something similar, could you
explain in more detail what colors you want, and under what conditions they
would be applied? Thanks.
 
B

Bernard Liengme

Read Help on Conditional Formatting
Come back with more questions but DO tell us the version of Excel you have
2003 (or earlier) or 2007
best wishes
 
L

loulou

I would like to colored the entire row for ecxample if in the column M+/M-
the value is M-06 I would like to put the entire row yellow, if the value is
M-5, I want it pink, if the value is A-2 I wanted blue and if the value is
M-01 I wanted green.

I have MS Excell 2007.
Thank you
Loulou
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top