Different colour for each formula result obtain in one cell

Closed

OM - Jan 22, 2015 at 09:25 AM

Hello,

In Excel , I want different format for formula result in one cell.

A1=0 & A2 = THANKYOU

=if(A1=0,"OK","NOT OK")&RIGHT(A2,5) ----- > A3

1ST PART : if(A1=0,"OK","NOT OK") : Colour -yellow i.e.Ok in red in A3

2nd PART : RIGHT(A2,5) : Colour - green.i.e THANK in green in A3

A3 : Ok Thank

Different colour for each formula result obtain in one cell
Crimping colour code - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Multiple functions in one cell - Excel Forum
Number to words in excel formula - Guide

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

Formula to subtract one cell value from another.

You disagreed with the decision facebook

Excel - IF function with multiple words

excel - send result of formula to another cel

How to calculate position (1st,2nd,3rd) in excel....?

Similar discussions

Subscribe To Our Newsletter!