is it possable to change the cell colour / text depending on the value of the
cell.... using VBE rather than conditional formatting

Hi Stan,

yes it is, and here's a link to a site with explanations of how to do
it:

http://www.cpearson.com/excel/colors.htm

Hope this helps.

Pete

Stan Halls wrote:

is it possable to change the cell colour / text depending on the value of the
cell.... using VBE rather than conditional formatting

Thanks for that but it seems to be the reverce of what i am after, What i am
trying to do is , if the cell value = 1 then cellcolour turns red , i know i
can do this in conditional formatting but if i do then i get an error because
i have gone over the 4,000 limit , i was hoping that doing it in VBE might
get me over the problem

"Pete_UK" wrote:

Hi Stan,

yes it is, and here's a link to a site with explanations of how to do
it:

http://www.cpearson.com/excel/colors.htm

Hope this helps.

Pete

Stan Halls wrote:

is it possable to change the cell colour / text depending on the value of the
cell.... using VBE rather than conditional formatting

Send me the sheet I would answer with solution.


Stan Halls a écrit :
Thanks for that but it seems to be the reverce of what i am after, What i am
trying to do is , if the cell value = 1 then cellcolour turns red , i know i
can do this in conditional formatting but if i do then i get an error because
i have gone over the 4,000 limit , i was hoping that doing it in VBE might
get me over the problem

"Pete_UK" wrote:

Hi Stan,

yes it is, and here's a link to a site with explanations of how to do
it:

http://www.cpearson.com/excel/colors.htm

Hope this helps.

Pete

Stan Halls wrote:

is it possable to change the cell colour / text depending on the value of the
cell.... using VBE rather than conditional formatting

colourindex will do that


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If mycell.Value = whatever Then colourindex = 3
End Sub

would change the cell to red if true

"Stan Halls" wrote:

is it possable to change the cell colour / text depending on the value of the
cell.... using VBE rather than conditional formatting

Sorry i might be a bit stupid on here but i cant seem to make it work

"Mike" wrote:

colourindex will do that


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If mycell.Value = whatever Then colourindex = 3
End Sub

would change the cell to red if true

"Stan Halls" wrote:

is it possable to change the cell colour / text depending on the value of the
cell.... using VBE rather than conditional formatting