Is there a maximum number of conditional format rules that can be applied?

AndyEvans

New Member
Joined
Jan 11, 2010
Messages
17
Hi All,

I need to add more conditional formatting to my spreadsheet. But it seems to belimiting me to 3. Is there a way of increasing it?

Thanks,

Andy
 
Firstly it is for a shift rota. I have the rota so I can enter a date and it shows me what the shift is working, Days or Nights. It also incorporates Rota'd Days Off which are a set pattern.
Just for ease, days are light blue, nights dark blue, RDO's are clear and weekends are a pattern.
I want it to be an all in one so I can keep track of holidays, days in lieu, sick days and overtime. I have set up another sheet with the rota mapped out for the next 10 years where I can use a range command buttons to change the colour and text of a selected cell denoting this.
Even thought the vlookup brings in the correct data from the cells, it doesn't import the formating.
The staff will only have access to the shift side of the rota so they can see thier own holidays and for other team members to see if there is room for their holidays etc.
I'm sorry if this is all a bit of a mix.If you would prefer to have a look at the file, pm me your email and I'll send it to you.
Thanks again for your help.

Andy
 
Upvote 0

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,223,627
Messages
6,173,425
Members
452,515
Latest member
Alicedonald9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top