Conditional Format Formula Ties

R

Rob

I am using this as a conditional format only problem is ties, I would like
only one of the ties to format true. This also takes care of empty cells.
=AND(A1<>"",A1<>" ",A1>=LARGE($A$1:$A$5,4))

thanks Rob
 

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

Similar Threads

Merging from an Excel file with graphics 1
MS Project. Real progress of the project, % complete 1
Excel does not accept text format! 0
VBA Coding Help for Beginner 0
Excel - Wich Function should I use? 1
Conditional Format four top four cells 16
Conditional Formatting --- copying to multiple rows 3
formula 2

Top