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
 
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)
 

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
Counting the number of rows based on the color 2
Conditional Formating with IF and AND formula 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