color of a cell within a nested if function

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

Guest

is there a way to assign the color of a cell based on the value of another
cell within a nested if function?

eg something like this formula in cell D350:

IF(D351<0.5,color of cell N353,IF(D351<0.7, color of cell N364, color of
cell N365))

i thinking some kind of conditional formatting maybe?

thanks
Ian
 
--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You need conditional formatting for this. Look up
'Highlight cells that meet specific conditions' in the Answer wizard in help


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

Excel VBA 1
Change Color of cell 3
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Formating with IF and AND formula 2
Counting the number of rows based on the color 2
Coloring a cell based off the color of another cell 4
Assigning a cell colors via IF-THEN statements 3
Apply color of one cell to other 2

Back
Top