
New Member

November 25, 2020

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!


July 16, 2010

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
1 Guest(s)
