Hi, I'm new to the forum but find the knowledge and help here fantastic!
I have an Excel question I could use some help on.
I know how to use Conditional Formatting for lowest value in a row.
And I am aware of this formula and have used it successfully within Conditional Formatting: =AND(J2=MIN($J2:$BA2),J2<>"")
What I need is the statement to include that if the values in the row are all the same to skip shading them.
Only shade when it drops in price.
Is this possible?
Thank you.
Try this instead
=AND(J2=MIN($J2:$BA2),J2<>"",COUNTIF($J$2:J$2,J2)=1)
Life's a spreadsheet, Excel!
Say thanks, Click *
Add this test:
NOT(AND($J2:$BA2=J2))
If you test that in a cell on the worksheet it must be array entered.
Array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks