conditional formatting

[dmw1716]

i would like to shade every other row and in addition in Column R have
an additional conditional format for the values if they are < or >=
0.

Essentially there will be 4 conditions,

1. grey shade and red font
2. grey shade and green font
3. white shade and red font
4. white shade and green font.

any suggestions?

 

[Bernie Deitrick]

Use one of your conditions as the default format, then use the others with CF , using the Formula Is
option, with the three formulas like

=AND(MOD(ROW($Axx),2)=1,$Rxx>=0)

=AND(MOD(ROW($Axx),2)=0,$Rxx>=0)

=AND(MOD(ROW($Axx),2)=1,$Rxx<0)

where xx is the row of the activecell at the time that you apply the CF.


HTH,
Bernie
MS Excel MVP

 

[dmw1716]

Use one of your conditions as the default format, then use the others with CF , using the Formula Is
option, with the three formulas like

=AND(MOD(ROW($Axx),2)=1,$Rxx>=0)

=AND(MOD(ROW($Axx),2)=0,$Rxx>=0)

=AND(MOD(ROW($Axx),2)=1,$Rxx<0)

where xx is the row of the activecell at the time that you apply the CF.

HTH,
Bernie
MS Excel MVP









- Show quoted text -

sorry forgot to mentiont that i dont want the entire row to be colored
in text but rather just Column R to be red or green font based on
value around 0