Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
The first conditional format is "=MOD(ROW(),2)=0". This auto shades every
other row and fixs the rows color so if I do a sort the rows will still be shaded every other row. The second Conditional Format is to color the font red if less than 0. However, if a negitive number is in a row that has been shaded, the font will not trun red, in the other rows the negatives are red. What can I do to have both the shaded cell and red negative numbers? As always, any help is very much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
list all conditional formats | Excel Worksheet Functions | |||
How do I add more Conditional Formats? | Excel Discussion (Misc queries) | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
how do i get more than three conditional formats in excel | Excel Worksheet Functions | |||
Conditional Formats in Excel | Excel Worksheet Functions |