Quote:
Originally Posted by Spencer101
You need to add another condition. This one based on a formula and before the one you already have. See the attached pic.
Make sure you set the background colour in the first condition as "No Fill" and it should work just fine.
|
Thank you. But it creats a problem. since my table includes the follwoing condition conditioning: =MOD(ROW(),2)=0
i end up with the picture below.
How can i keep the format where i have one line blue and the other white and only then apply the rule where if somethign is greater the "0" then is colored red.
Thanks.