Log In
Register
Home
New Member
November 25, 2020
Offline
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
Offline
Hi Louise,
Welcome to our forum.
Is the order of the Ps and Qs important, or just the number of them?
Mynda
New Member
November 25, 2020
Offline
Thanks!
No, the order doesn't matter, only the number. As long as there are 2 of each in each column.
Louise
July 16, 2010
Offline
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)
