SHEET CODE to edit cell formats based on contents

J

jamie.gill

New Member
Joined
Jan 28, 2011
Messages
30
These are the values and their formats
MPC1 = Red
MPC3 = Pink
MPC4 = Yellow
MD01 = Green
Mm2b = Cyan
FP1 = Purple
PH01 = Blue
PH05 = Orange
IT3 = Black

Each with white text.

im no good with vba so am pretty hopeless
 
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

R
  • Question Question
Search a range for a specific color of rows, relocate those cells to another sheet, return previous sheet formatting to blank and sort secondary sheet
Replies
4
Views
402
Royalbloodi
R
Q
  • Solved
VBA Macro to Find Missing and Duplicate Data
2 3
Replies
20
Views
1K
kevin9999
K
K
  • Solved
Need help with formatting a cell which uses a drop down to display status when the date is older than today
Replies
1
Views
804
6StringJazzer
6StringJazzer
W
  • Question Question
Condition formatting rule based on colour or number in another cell that already has a formula (without code)
2
Replies
11
Views
2K
Woodpusher147
W
W
  • Question Question
If cell value less than X, a new sheet is created based on a template
Replies
4
Views
527
Legacy 143009
L

Share this page

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