Format a cell color if meets certain criteria

[chasethewind]

Hello,

I cannot figure out how to format a cell to a certain color with a simple IF statement.

Example

=IF(C3=4,Change C3 to Red,Do nothing)

I would like not to use the conditional formating, macros, or VBA to accomplish this task. My ultimate goal it to change all cells within the entire worksheet with "#N/A" to color white. Can this be accomplished?

Thanks.

 

[mintjulep]

Conditional formatting is THE THING to do this with.

Why do you not want to use the thing that does what you want to do?

 

[Lilliabeth]

A formula can't change a different cell. And a formula can't change formatting. The answer to your question then is no, for 2 reasons.

Conditional formatting is the way to do what you want.

--Lilliabeth

 

[SkipVought]

Hi,

I'd like to get to Philadelphia from Dallas in 15 minutes, but it ain't gonna happen in my lifetime.

Conditional Formatting is your answer. I use CF often to do EXACTLY what you need.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[chasethewind]

Is conditional formating considered a macro? I do not want any macros in my spreadsheet.

 

[lionelhill]

no, it's not a macro, and it doesn't pose any security risk, and it works even when macros are disabled.