# 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

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.
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.