Is there a way to have excel automatically highlight a cell with a formula in it if the formula displays a postive number? I need to highlight the entire cell if the number is positive and not highlight if the number is negative automatically. I don't think theres a way and might have to just have black and red numbers but would prefer the entire cell. Any help? Thanks!