Macro Changing Text Color

[elisitamariel]

Hello,

I'm trying to complete the following:

I have a range of cells using the below formula:

=IF(ISBLANK(A8),P7,A8)

What I would like to do is create a macro that can help me change the text color to white of those cells where the above argument comes out as true.

Can that be done?

Thanks for your help.

 

[Roderick_E]

No need to use a macro which sounds like it may be a more complex process. You could set up a Conditional Format. Depending which Excel version you are using; look at HOME/Conditional Formatting

 

[L. Howard]

Looks like Conditional Formatting will do that, unless you have a compelling reason for wanting a macro.

Regards,
Howard