View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved Steved is offline
external usenet poster
 
Posts: 519
Default 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