ExcelBanter - If date in column T is +7 then column C is Bold Red

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If date in column T is +7 then column C is Bold Red (https://www.excelbanter.com/excel-discussion-misc-queries/136336-re-if-date-column-t-7-then-column-c-bold-red.html)

Max

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

All times are GMT +1. The time now is 05:34 PM.