Thread: If date in column T is +7 then column C is Bold Red
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default If date in column T is +7 then column C is Bold Red
Select col C (C1 active), then apply cond format using the formula:
=AND(ISNUMBER($T1),$T1TODAY()+7)
Format as desired: bold/red?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"writerman" wrote:
If date in column T is +7 then column C is Bold Red
Reply With QuoteReply With Quote