Hi,
I have two columns that contain formulae so that ones displays a number (1-4) and the other a letter (A-D).
I want to apply conditional formatting when the two cells display certain number letter combinations....for example when column 1 shows 4 and column 2 shows D.
Basically is there a way to apply conditional formatting to a combination of two cells, or otherwise is there a way to get the information displayed in two cells into one cell.....i.e 4 and D becomes 4D in another cell
Thanks for the help
Bookmarks