Help with Conditional Formatting and Fomulas

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

Guest

Hello,
I am wanting to have certain cells within my sheet change color based on
the value of a named cell, the named cell is called MaxLvl, basically every
time it reaches a certain threshold I need to have another box change color,
I have tried putting into the conditional formatting the folowing formula

=if(MaxLVL>3,"","")

The value of MaxLVL is 4 at the current time and yet no formatting changes
are appearant. Please help.
 
Your CF formula needs to return TRUE/FALSE. Try

CF1: =MaxLVL>3
Format1: <color>
 
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

Conditional Formating with IF and AND formula 2
Excel conditional formatting with Weeknum 4
Help with Conditional Formatting 2
Excel VBA 1
how do i conditional formate a text box 3
conditional formatting 1
help with IF cell meets certain condition..then do the following 3
conditional Formatting help 2

Back
Top