COLORIZE ONLY… (2000)

Topic

New Reply

Hi,

in this sheet is present a range of DATE, G2:BN2000 my problem is:

colorixe in font RED all date >TODAY(), and colorize in yellow the background and cell in font RED BOLD to calculate in 25% of every line:

example:

1) range G2:BN2 colorize G2:R2 because are >today()
2 range G2:BN2 colorize the cell U2 because the cell is 25% of G2:BN2 (60/4=15)
range G2:BN2 colorize the cell R2 because the cell is 25% of G2:BN2 (48/4=12)

this condition in the range G2:BN2000 if in this range are present a many DATE

Tks.

Reply | Quote

Replies

select G2:BN2000
Format -cond format
Formula is:
=AND(G1<TODAY(),(COLUMN(G1)-COLUMN($G$1)+1)=($D2*0.25))
Font Tab: Color red, Style:Bold. Patterns tab: Choose ‘Yellow”

Cell Value, less than, =TODAY()
Font Tab: Color red

Formula is:
=(COLUMN(G1)-COLUMN($G$1)+1)=($D2*0.25)
Font Tab: Style:Bold. Patterns tab: Choose ‘Yellow’

Cond 1 will set Yellow background, red bold font if <Today and the column is "25%" column
Cond 2 will set red font if <Today
Cond 3 will set back yellow and bold font if column is <25%

Order of cond 2 and 3 is immaterial, but cond 1 with the AND must be first, since the conditions are checked (in order) until a True one is found.

Steve

Reply | Quote

great wizard

Reply | Quote

great wizard

Reply | Quote

as usual difficult to translate in italian function. Like to send or attache my file with yor modification?
gss.italy@iol.it

Reply | Quote

Here it is

Steve

Reply | Quote

Here it is

Steve

Reply | Quote

as usual difficult to translate in italian function. Like to send or attache my file with yor modification?
gss.italy@iol.it

Reply | Quote

select G2:BN2000
Format -cond format
Formula is:
=AND(G1<TODAY(),(COLUMN(G1)-COLUMN($G$1)+1)=($D2*0.25))
Font Tab: Color red, Style:Bold. Patterns tab: Choose ‘Yellow”

Cell Value, less than, =TODAY()
Font Tab: Color red

Formula is:
=(COLUMN(G1)-COLUMN($G$1)+1)=($D2*0.25)
Font Tab: Style:Bold. Patterns tab: Choose ‘Yellow’

Cond 1 will set Yellow background, red bold font if <Today and the column is "25%" column
Cond 2 will set red font if <Today
Cond 3 will set back yellow and bold font if column is <25%

Order of cond 2 and 3 is immaterial, but cond 1 with the AND must be first, since the conditions are checked (in order) until a True one is found.

Steve

Reply | Quote