PDA

View Full Version : concatenate in conditional formatting?



oliver
12-04-2008, 05:29 AM
Is it possible using conditional formatting to look at say cell A1 and if it has a
value >0, it will concatenate that value with a space to the text that is in A2?
A1 would always be numeric and A2 always text.
Thanks
Oliver

Bob Phillips
12-04-2008, 06:39 AM
Concatenate is simple but how does this impact on CF. Unless you mean something like

=AND(ISNUMBER(A1),NOT(ISNUMBER(A2)))