Need your help for 3 major problem

[Pankaj16]

I hope my problems ( see uploaded file, 3 issues in 3 sheets) will be very easy for you. kindly help

 

[Sathish KV]

Hi,

For the 1st issue use 'Cell value is' instead of 'Formula is' in conditional formatting

Will comback on the remaining issues

 

[Deepak]

For 1: Use CF as =(F1=TODAY())

 

[Sathish KV]

Hi,

Use the below procedure for the 2nd requirement

Sub Formatting()

  Range("A1").Select
  
  On Error GoTo Err
  Do Until ActiveCell.Column = 20000
  Columns(ActiveCell.Column).Interior.ColorIndex = 6
  Columns(ActiveCell.Offset(0, 1).Column).Interior.ColorIndex = 3
  Columns(ActiveCell.Offset(0, 2).Column).Interior.ColorIndex = 44
  Columns(ActiveCell.Offset(0, 3).Column).Interior.ColorIndex = 1
  
  ActiveCell.Offset(0, 5).Select
  Loop
  
Err:
  
End Sub

 

[Deepak]

For 1: Use CF as =(F1=TODAY())

Pls check attached file for 1 & 3 where vb code is already provided for 2nd.

 

[Sathish KV]

Hi,

The 3rd issue needs more explanation

Is the date range going to be changed for each item/description

 

[Pankaj16]

Yes , If project will change the priority of the document in future then date range will be change.

 

[Pankaj16]

Different document is having different start and end date , and these range can be change as per the project priority.

 

[Sathish KV]

Hi,

The challenge in your 3rd task is how to arrive at start date and end date for a project based on coloring

We will not be able to create conditional formating based on color of cells

Let me explore other methods and come back

 

[Pankaj16]

I have a logic but dont know how to transform it into code.

logic is " we cross check IS CELL COLOR = YELLOW, AND IS DATE IS TODAY

IF YES THEN CELL COLOR ( RELATED LEFT SIDE DOCUMENT LIST CELL) = GREEN

THIRD FLAG IF DATE IS LESS THAN TODAY THEN CELL COLOR = RED