Conditional Formatting
2 Attachment(s)
Hi All,
i have the table below. I added the conditional formatinng below to these cells. however, the "blank" cells are colored red instead of only cells with value greater then "0". anyone? |
1 Attachment(s)
Quote:
Make sure you set the background colour in the first condition as "No Fill" and it should work just fine. |
Conditional Formatting
Hi Dorian,
Am Thu, 5 Apr 2012 06:21:38 +0000 schrieb Dorian74: i have the table below. I added the conditional formatinng below to these cells. however, the "blank" cells are colored red instead of only cells with value greater then "0". a cell has value=0 if the cell is empty. But you have a formula in it. Try CF with formula: =AND(ISNUMBER(N4),N40) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
1 Attachment(s)
Quote:
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. |
Quote:
|
Quote:
|
Quote:
|
Quote:
however, i was woundering regarding pasting the formule in alternate rows. is there a way to paste it in all the alternate rows automatically not manually? |
Quote:
It will also work if you have two formulas that you want to alternate all the way down. Put formula one in the first row and formula two in the second, highlight the two cells and drag down as necessary. Hope that helps. |
Quote:
|
All times are GMT +1. The time now is 12:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com