excel colour formatting problem

**Brad1966** · 10-21-2009, 02:38 AM

Appreciate any help!

I have a date table with a series of column inputs beside it..
ie For the date 5th Nov 2009 entered in cell b2, i have 3 cells c2, d2, e2 which may or may-not have an entry ie either nthg or say "L"

I want to display in f2 the text inputs from c2-d2-e2 if they have say the value"L", but wish to differentiate these results by colour

ie if the relevent cells have a value i want to differentiate and display these in f2 as...c2 in Red, d2 in blue, e2 in green.

if any of the c2, d2, e2 values are blank i want to exclude them

how can i achieve this without any VBA?

Thx in advance

**DonkeyOte** · 10-21-2009, 03:05 AM

If I've understood you, you can't. A cell containing a formulae can not contain more than one format. You would need VBA.

**rwgrietveld** · 10-21-2009, 03:10 AM

I understood:
F2:=IF(OR(C2="L",D2="L",E2="L"),"L","")
CF F2:=
CF 1) =IF(AND($C$2="L",$D$2<>"L",$E$2<>"L"),1,0) => Border Red
CF 2) =IF(AND($C$2<>"L",$D$2="L",$E$2<>"L"),1,0) => Border Blue
CF 3) =IF(AND($C$2<>"L",$D$2<>"L",$E$2="L"),1,0) => Border Green

The only thing I do not understand is

if any of the c2, d2, e2 values are blank i want to exclude them