if cell blank color "red"
Hello from Steved
Thankyou for your reply
Question please and that is Can I apply Set condition to if cell value = ""
only if the cell has a formula in it, as at the moment it does it to all
blank cells.
I thankyou.
"Luke M" wrote:
Select etiher the whole column, or just the cells with your formula. Go to
Format-condition format.
Set condition to if cell value = ""
Click format, and pick the red pattern.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Steved" wrote:
Hello from Steve Dee
In Column U:U I have the below Formula ( Office 2007 )
=IF(+S108-T108<0,"",+S108-T108)
I would like please if the cell is blank the cell to change to color "Red"
I thankyou
|