Conditional Formatting - Stumped Again

bds

Board Regular
Joined
Jul 7, 2007
Messages
84
I have the following conditional formatting applied to a row of cells:

Formula is =MOD(ROW(),2)=0 (put border top and bottom)
Cell Value is > =AVERAGE($E2:$IV2)*1.3 (apply blue type)
Cell Value is < =AVERAGE($E2:$IV2)*.7 (apply red type)

Now I have the same conditioning applied to all the rows of data. Most places it is working just fine. The top line of where I have it applied is not working though. If I insert a blank row above it, it works fine. I don't want to insert a blank row though. Why is it behaving this way and is there an alternative fix?
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Diffy

Well-known Member
Joined
Dec 22, 2006
Messages
512
The way you have it set up you have a top and bottom border every other row. This results looks like you have a horizontal border EVERY row. Is this what you want?
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
I don't think that you can get a top border in row 1 - with CF or otherwise. Of course I might just be a complete dork.
 

Diffy

Well-known Member
Joined
Dec 22, 2006
Messages
512
VoG, true, you may not see it when you are working with your spreadsheet, but it is certainly there when you print the sheet.
 

bds

Board Regular
Joined
Jul 7, 2007
Messages
84
Sorry - I wasn't really clear with my question. The borders are fine. However, the formulas to change the text colors of numbers above and below average aren't working on the first row below the headers - but are working on all the other rows.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,517
Messages
5,596,620
Members
414,081
Latest member
Subaru_Steve

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top