danomaniac
Programmer
I'm having difficulty getting my conditional formatting to do exactly what I want. I have data in 5 columns spanning many rows. The left column is populated with weekly dates through the end of the year and every week data is entered in the columns to the right. The first column of data is the critical entry. If it is blank, nothing has happened and the spreadsheet assumes it is in the future. From that row on down in the next columns, I have projected values into the future based on the value entered. I want future values to be formatted gray and past values to be black based on whether or not the first cell is blank. Easy enough. The problem is, I also want to know when a future value reaches a certain point, say, zero.
default format = black text
condition 1: cell formula =ISBLANK($B1) formatted gray text.
condition 2: cell value = 0 formatted green text
The second condition never works. I've also tried setting the default to green. Then if cell b1 is blank, gray, not blank, black. Doesn't work.
I would appreciate any suggestions. Thanks.
"It's more like it is now, than it ever has been."
default format = black text
condition 1: cell formula =ISBLANK($B1) formatted gray text.
condition 2: cell value = 0 formatted green text
The second condition never works. I've also tried setting the default to green. Then if cell b1 is blank, gray, not blank, black. Doesn't work.
I would appreciate any suggestions. Thanks.
"It's more like it is now, than it ever has been."