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
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,626
Messages
5,838,429
Members
430,547
Latest member
jopshio

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