Highlight Cells based on date

[VKKT]

Hi All,
Greetings:

I have the attached leave schedule for staff. Is it possible to highlight the date cells as shown in the excel sheet based on the changes in the data in column B, C & E.

Regards,
VKKT

[HansV]

You can do this using Conditional Formatting. To view the rules, select Conditional Formatting > Manage Rules... on the Home tab of the ribbon.

Leavesch.xlsx

[VKKT]

Great, thanks Mr. Hans
regards,
VKKT

[VKKT]

Hi,
Greetings:

I have attached a leave schedule, is it possible to highlight all the leaves in one row as shown in the bottom of the attachment.

Regards,
VKKT

[HansV]

That would be complicated.

[gailb]

I would adopt a data validation method.

[VKKT]

Greeting:
Thanks Hans/gailb

I had managed it by adding additional cells for dates as shown in the attached.

Now I want to highlight the cells where another cell contains a specific value (attached the sample) I had tried but not successful.

Regards,
VKKT

[HansV]

Your sample workbook doesn't explain what you want to do...

[VKKT]

Sorry Hans, I had attached wrong file. Now updated with the correct one

thanks
VKKT

[HansV]

Select V5:AY13. The active cell in the selection should be V5.
Create a new conditional formatting rule of type formula with formula

=V$3="H"

Here, V is the column of the active cell; this is relative because it must change for the other columns.
3 is the row that may contain "H". This is absolute since it should not change for the other rows.
See the attached version.

Schedule of leave-sample1.xlsx

[VKKT]

Thanks a lot Hans for your support.

I had used wrongly =$V$3="H"

Regards,
VKKT