Quote:
Originally Posted by Dorian74
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?
|
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.