I'm trying to create conditional formatting for cells C28-Z28 based on text in the columns above. There are shortcut keys set up (listed on sheet) to put a 'p', 'q' or 'pq' into each cell. I need a total of p, p, q, ,q OR p, q, pq, OR pq, pq in the column to format the bottom cell (row 28) as green. How do I make it do this?
Thanks!
Hi Louise,
Welcome to our forum.
Is the order of the Ps and Qs important, or just the number of them?
Mynda
Thanks!
No, the order doesn't matter, only the number. As long as there are 2 of each in each column.
Louise
Hi Louise,
So, if there are two or more cells with a p or q or pq then you want row 28 highlighted green you can use COUNTA to count the number of cells containing text is >=2.
See attached.
Note: your file has shortcut keys listed, but those are shortcuts that already perform actions Excel users perform all the time i.e.
CTRL+A = Select All
CTRL+S = Save
CTRL+D = Duplicate
I recommend choosing shortcut keys that aren't already used.
Mynda
