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 “GOOD”
back ground color3 if B1=3 with a text in C1 as “BETTER”
else
back ground color1 with C1=D1
Priority of CF as above.
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 “GOOD”
back ground color3 if B1=3 with a text in C1 as “BETTER”
else
back ground color1 with C1=D1
Priority of CF as above.