In my spread sheet I wanted to high 1

[bnageshrao]

In my spread sheet I wanted to highlight fields whenever a user tabs out of that field by not entering any values. I wrote the quote and it worked fine by highlighting the cells whenever they left it blank. Now whenever they fill out those blank fields I want that cells color returned to the original color. I wrote the code but that changes it to original color only after clicking on the cell 2 times. I dont know where I am going wrong, all I want is as soon as they enter the values the color should change back to original color. Any help out there? Thanks.

 

[DarkSun]

have you tried conditional Formatting??

Just set it to:

Cell Value is Equal to =""

Then set the format to colored backgroud.

This means when there is no value the cell is colored.

 

[bnageshrao]

I picked up a range of cell and for those cells I set the conditional formatting to turn the blank cells to green otherwise the original color for the non blank cells. When I did this nothing happened to those blank cells. Did u try it or anyother means? Thanks

 

[bnageshrao]

It worked when I set cell value = 0