View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashok Thapar Ashok Thapar is offline
external usenet poster
 
Posts: 2
Default Format individual coloumn cell with corresponding coloum cell resu

I wish to Format individual coloumn cell with corresponding different coloum
cell result.
I have text of various observations in coloumn F. Coloumn G contains
"expected time for competion in days" ( which is different for each
observation in col.F). Col. I has the status details (viz. "Completed" or "In
Progress") of each observation. I wish to highlight each cell of col. F with
Red color for the condition where the "expected time for competion in days"
lapses with respect to current date (Today() ) but the status is still "In
Progress".