I have in a cell IF(A1=B1,"same","diff") .
How can I cause diff to appear in a colour other than black, if A1 is not the same as B1?
Thanks!
Colouring the result of an IF statement
-
John Gray
- PlatinumLounger
- Posts: 5420
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Colouring the result of an IF statement
John Gray
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...
-
VegasNath
- 5StarLounger
- Posts: 1185
- Joined: 24 Jan 2010, 12:02
- Location: Wales, UK.
Re: Colouring the result of an IF statement
Conditional formatting....
Cell value is
equal to
diff
Set the format as desired.
Cell value is
equal to
diff
Set the format as desired.
Nathan 
There's no place like home.....
-
John Gray
- PlatinumLounger
- Posts: 5420
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Re: Colouring the result of an IF statement
Thanks!
Six minutes for you to reply (and before Hans!!); probably at least double that long for me to find Conditional Formatting in the Excel 2010 ribbon...
Later Which wasn't helped because quite some time ago I had removed Styles from all toolbars in Word and Excel as never likely to be wanted, and thus a waste of horizontal ribbon space...
Six minutes for you to reply (and before Hans!!); probably at least double that long for me to find Conditional Formatting in the Excel 2010 ribbon...
Later Which wasn't helped because quite some time ago I had removed Styles from all toolbars in Word and Excel as never likely to be wanted, and thus a waste of horizontal ribbon space...
John Gray
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...
"(or one of the team)" - how your hospital appointment letter indicates that you won't be seeing the Consultant...