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
Hi,
Yes, it's possible. To do so you should use "Formula is" instead of "Cell Value Is". Create a condition just like you would do in an IF, when it's true the conditional format will be activated.
=AND(A1=2,B1="D")
Success,
Erik
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks