EXCEL 2007 NO VALUE= NO COLOR [Solved/Closed]

out o' ideas - Feb 1, 2010 at 10:30 AM - Latest reply:  out o' ideas
- Feb 1, 2010 at 11:34 AM
Hello,
I've conditionally formated multiple cells to highlight green when the inputted date is within a 2 year period and red if it exceeds 2 years. The problem I have, is that any cell that does not have a value entered into it, i.e. the cell is blank, has defaulted to red. It makes sense why, but I haven't figured out what additional conditional formula I can add that will allow the cell with no value to remain white/no fill. I've tried "0", "a1=0", "today()-a1=today()" for example with no luck. How do I get cells, with no value/data, to remain white?

Thanks
See more 

2 replies

Best answer
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Feb 1, 2010 at 10:36 AM
1
Thank you
What formula are you using to define the two conditions ? Conditional format is triggered when conditions are met so it seems that your formula have a logical error. Could you share how you have applied the conditions ?

Thank you, rizvisa1 1

Something to say? Add comment

CCM has helped 1701 users this month

out o' ideas - Feb 1, 2010 at 11:34 AM
0
Thank you
In excel 2007, I'm using the "Use a formula to determine which cells to format" under the New Formatting Rule option. You input the formula and then set the format desired for a true statement. I was able to finally figure out how to make the cells with no value be white. I had to use the "Format only cells that contain" option instead of the one used above, and define it as blanks to be formated as white. This has worked, though I'm sure there should've been another way without having to have defined yet another condition.