conditional formatting

  • Thread starter Thread starter dmw1716
  • Start date Start date
D

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?
 
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
 
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 -
Click to expand...

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
 
Back
Top