[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

Excel 2013 -- Conditional Formatting ?

What formula will make the attached RED work ?
  ** if cell J# less than or equal K#
     then nothing
     else make cell J# background RED
s013.jpg
0
finance_teacher
Asked:
finance_teacher
1 Solution
 
NBVCCommented:
It looks like your picture shows the reverse of what you spell out in text...

by the picture:

Select J2 to last cell in J range, go to Home>Conditonal Formatting, then choose "Format only cells that contain" from top section.

Then select Cell Value >> Less Than from bottom section, then enter =K2

Now click Format and choose from Fill tab.

If you want it the other way, then Cell Value >> Greater than =K2
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now