VBA font color change ?

[audrey]

Hello,
with a checkbox button, I would like to have;

- Font change color (from white to black, black to white)
- Background change color (from white to black, black to white)

is that possible ?

It s not the whole sheet it should apply, lets say only A1:b3

Thanks for your help!

 

[pingpong777]

Hi. Thanks, but I'm trying to get the coding to use in the format cells editor (snapshot below). for basic colors such as red and blue, you can put [Red] or [Blue] at the beginning of the format definition, but I am hoping to use the 175,11,28 color rather than Red or Blue, and I'm not sure of the syntax.

 

[pingpong777]

sorry, i guess i'm not able to upload a jpg. i'm clear on specifying font color in VBA, but trying to figure out how to do it in a custom number definition in the actual excel Format Cells dialog.

 

[UMAKEMESIK]

sorry, i guess i'm not able to upload a jpg. i'm clear on specifying font color in VBA, but trying to figure out how to do it in a custom number definition in the actual excel Format Cells dialog.

-------------------------

You most likely already know this and that is why you are on Mr.Excel....

but I find this on the Web.

"I am afraid that many properties of Excel objects are accessible only from VBA. But the info you want can be obtained with a 3-liner and you can use such a user-defined formula within your excel sheets just like a built-in formula. If wanted I can post a VBA solution for you. The =CELL("color"..) pertains to contitional formatting – "

 

[pingpong777]

i kind of i figured conditional formatting would be the ultimate route... thanks for the help.