Conditional Values affecting another Cell

**dlenoxx** · 03-06-2009, 03:01 PM

I was curious if it was possible to have a cell's formatting be altered using the conditional values tool.

Example: if(A1=A2,A3=redfont,A3=automaticfont)

I know it wouldn't work like that, but it does show what I'd like to happen.

**deadlyduck** · 03-06-2009, 03:08 PM

Yes- in the Conditional formatting dialog box, instead of "Cell value is" choose "Formula is" and enter =A2=A3 as the condition. Then click the "Format..." button to apply the desired format to the font.

**dlenoxx** · 03-06-2009, 03:59 PM

Originally Posted by deadlyduck

Yes- in the Conditional formatting dialog box, instead of "Cell value is" choose "Formula is" and enter =A2=A3 as the condition. Then click the "Format..." button to apply the desired format to the font.

I did that before I posted and it didn't work for some reason. I'll attempt again...

Well son of a gun.

Thanks!