Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Conditional Formatting
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? |
#2
|
|||
|
|||
Quote:
Make sure you set the background colour in the first condition as "No Fill" and it should work just fine. |
#3
|
|||
|
|||
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. Last edited by Dorian74 : April 5th 12 at 02:39 PM Reason: forgotten attachment |
#4
|
|||
|
|||
Quote:
|
#5
|
|||
|
|||
Hi, i'm just not that creazy about the way it screws up the table i already made.
|
#6
|
|||
|
|||
Then I would suggest you go with Claus' CF formula ( =AND(ISNUMBER(N4),N40) ) in combination with the alternating rows one you already have.
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |