Can I put the =MOD(ROW() condition behind manual formatting?

[jdpro]

I like to use the =MOD(ROW(),2)=0 function to make my data easier to read, but in many cases I have to highlight individual cells. If I have the MOD function in a range I can only highlight clear cells that are not affected by the modification. Is there a way to put the modification in the background so that I can highlight individual cells with another color?

Thanks!!

 

[MARK858]

If you mean you are using =MOD(ROW(),2)=0 in conditional formatting then no, conditional formatting always takes priority over normal formatting

 

[jdpro]

Thanks for your reply Mark. I thought that might be the case.

 

[Fluff]

You can actually do that if you are happy to save the workbook as an xlsm or xlsb & have macros enabled.
In the name manager create a new name (I've called it IsColour) & in the refers to box put

=GET.CELL(63,INDIRECT("rc",FALSE))

You can then change you CF rule to

=AND(IsColour=0,MOD(ROW(),2)=0)

 

[jdpro]

I will keep that in mind Fluff, and give it a try when I make a new one and want to try that out.

 

[Fluff]

Glad we could help & thanks for the feedback.