Aussiebear
07-10-2008, 06:31 AM
In the attached workbook, I need to change the font characteristics depending on whether the contact is Future, Active or Closed. I could individually apply conditional formatting on a row by row basis by wish to do so by using Code.
As a Contract is entered on the sheet, the font needs to be light purple (or mauve, I can never tell the difference, and non bold). This type of Contract "Future" has zero tons (Column I) recieved against it.
When a Contract becomes 'Active", the font needs to change for the row to Blue and Bold.
When a Contract becomes 'Closed", the font needs to change for that row to Grey and non bold. This type of Contract becomes closed when the value in Column C becomes "Yes".
I have applied a password "Password" to protect the sheet with only the values in Columns I & K unlocked, as this is how the User will see the sheet.
Ocassionally a person with Admin rights will delete Contracts from the sheet, hence the need for the formatting to be applied by code.
As a Contract is entered on the sheet, the font needs to be light purple (or mauve, I can never tell the difference, and non bold). This type of Contract "Future" has zero tons (Column I) recieved against it.
When a Contract becomes 'Active", the font needs to change for the row to Blue and Bold.
When a Contract becomes 'Closed", the font needs to change for that row to Grey and non bold. This type of Contract becomes closed when the value in Column C becomes "Yes".
I have applied a password "Password" to protect the sheet with only the values in Columns I & K unlocked, as this is how the User will see the sheet.
Ocassionally a person with Admin rights will delete Contracts from the sheet, hence the need for the formatting to be applied by code.