Conditional Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to highlight in red if a specific value is between 30% and 50% lower.

Thanks

JPG
 
Since you have not made any cell references or given any values, I will make
the comparison between A1 and B1 with B1 being the value to check and see if
it is lower than A1. In B1, create the conditional format as follows:

CONDITION 1: Set to "Formula Is" and then add the following formula:
=AND(B1<>"",B1>=A1*.3,B1<=A1*.5)
Then set your highlight to red
 
.... than what?

You could use Format/ Conditional Formatting/ Cell Value Is/ between/
=50%*A1/ and/ 70%*A1 if you are trying to compare the active cell with cell
A1.
 
You must log in or register to reply here.

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

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
conditional formatting bug? 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
conditional formatting 1
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
conditional formatting - highlight Capital letters but not lower c 2
Condtional Formatting and Standard Deviation 2

Back
Top