CONDITIONAL FORMATING

[Paulo Delgado]

Hello Everyone!

I am trying to format a few lines according to the previous line, that is, I wanted the next line to have a color gradient according to the previous line where the limit values are stipulated.

For example:
Line 4 the maximum values are entered, with different values in several collums.
Line 5 is sales, so I wanted line 5 to go yellow above 90% of line 4 and turn red when greater or equal than 100% of line 4.

Can you help me?

Best Regards From Portugal,
Paulo

 

[GraH - Guido]

Hi Paulo,

Like this perhaps?


formulas are
for red : =C$5>=C$4
for amber: =C$5>=90%*C$4

Now if you need this for each uneven row number, the formula needs some tweaking.

EDIT: added a file where CF is working for ODD rows.
e.g. =AND(ISODD(ROW()),C4>=C3)

 

[p45cal]

See formatting in attached.
I initially added the formatting to all the cells in the table, then filtered the table to only see Allot rows, and deleted the conditional formatting from the visible cells.

 

[Paulo Delgado]

Hello Everyone!

I am trying to format a few lines according to the previous line, that is, I wanted the next line to have a color gradient according to the previous line where the limit values are stipulated.

For example:
Line 4 the maximum values are entered, with different values in several collums.
Line 5 is sales, so I wanted line 5 to go yellow above 90% of line 4 and turn red when greater or equal than 100% of line 4.

Can you help me?

Best Regards From Portugal,
Paulo

Hello G!

Thank you very much for for help! That file is perfect!

I have to study that formula well so i could understand it. LOL but i think that i can understand what you did.

Thanks a lot!

Best regards!

See formatting in attached.
I initially added the formatting to all the cells in the table, then filtered the table to only see Allot rows, and deleted the conditional formatting from the visible cells.

Hello p45Cal!

Thank you for your help to!

Best regards!