Conditional formatting

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
Hi folks. Can I have more than 3 conditional formats on my spreadsheet that I am now creating?

_________________
Sorry, did you say your name was "Jaco Pastorius"?
This message was edited by J62Dennis on 2002-10-01 08:15
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
Hi -welcome to the board!

Short answer - yes, but it will need VBA.

It's a fairly common request - so my first suggestion would be to search this site for something like 'conditional format more', browse through the results to see if you understand the various methods, then post back with a bit more info on what you're actually trying to do in this case...

Paddy
 

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
Hi Paddy. Thanks for your response. In short, I have 3 conditional formats that are assigned to areas J to MN cell areas J4 thru J45 and AN 4 thru AN 45. The 3 conditionals i have in place are ="X" to turn cell red if absent; ="off" to turn blue if scheduled day off and currently ="w" for a pretty soft yellow is person is working their shift.
I am breaking up my work group into 5 shifts for 24 hr coverage. I want each shift to turn their cells a specific color, while leaving those other formats in place.
What do you think?

Thanks
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
should be fairly straightforward - did you find any previously posted examples that used the 'case' method in VBA?? (i.e. case 1 this, case 2 that etc) what did you make of them?

paddy
 

Watch MrExcel Video

Forum statistics

Threads
1,127,623
Messages
5,625,938
Members
416,143
Latest member
JoyceMB

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
Top