CF with a differnce

[hsandeep]

In cell C1 I have done CF. C1=D1.
CF (in C1):
CF1: If cell value>0, back ground color1

Output required:
I want to check value in B1. B1 generates thr’ formula either of 1,2,3,4 or null.
If B1=either of 2 or 3, then
MODIFIED CF (in C1) required as:
back ground color2 if B1=2 with a text in C1 as “RUN”
back ground color3 if B1=3 with a text in C1 as “TAKE-OFF”
else
back ground color1 with C1=D1

Priority of CF as above.
I don't know whether this is possible or not. Thanks for having .....

 

[ITWare2008]

Hi Hsandeep

I used the following formula in cell c21 to retrieve "Run", "take-off" or the value in b21

IF(A21=2,"Run",IF(A21=3,"Take-off",B21))

cell A21 generates a random number between 0 and 4. if it is 2 my cell c21 shows run, if it is 3 c21 shows take-off else c21 shows the number (or anything else) in cell b21

I also used a conditional format for the different background colours according to the results

=$A$21=2 -> uses yellow
=$A$21=3 -> uses green
=or($a$21<2,$A$21>3) -> uses blue

I hope this could help you.

Vândalo

 

[hsandeep]

Thanks ITWare2008. It WORKS. Moreover, splendid idea to achieve the goal. Thanks again.