Conditional Formating

deanNYC

New Member
Joined
Feb 27, 2019
Messages
7
Hi,
I am looking to highlight two shifts on a work rota using conditional formatting but am really struggling. The shifts I am looking to highlight are 2pm to 10pm and 3pm to 11pm. How can I achieve this please?
Thanks,
Dean
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
You can put examples of how you have the data in the cells.
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
Some examples!



I know you have 2pm to 10pm in the cells, but in which cells?
also 3pm to 11pm in which cells

You could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
 
Last edited:

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
I can not download the file. It says the folder does not exist
 

Watch MrExcel Video

Forum statistics

Threads
1,108,787
Messages
5,524,875
Members
409,608
Latest member
GigaPat

This Week's Hot Topics

Top