Conditional Formatting

S

Steve

Hi, is it possible to conditionally format a column based on the data
in two other columns?

For example

KI KJ KK

19/08/2013 19:30:00 131
26/08/2013 14:55:00 152 *
08/02/2013 15:50:00 164
26/08/2013 14:55:00 138 *
14/08/2013 19:15:00 126
22/08/2013 14:30:00 124
24/08/2013 16:05:00 126
17/08/2013 17:40:00 159
14/07/2013 15:10:00 163
24/08/2013 15:45:00 122


What I would like to do is CF each cell in KK where the value in cell
KI and KJ are the same so in the example above the cell starred would
be CF as both have the same date and time.

Any help as always appreciated


Regards


Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top