fill a cell with a color in excel Solved

Question

Hello,  I would like to know if it is possible to fill a cell with a color using a formula.  I have searched several forums and read that the solution would be VBA.  I don't know this software and apparently it is not installed by default with Excel. Also, I am a novice with Excel, apart from a few basic formulas, VBA seems beyond my "comprehension."  So that's my topic.  I have a table. When I enter a number that is between a and c, I would like the cell to become green and gray if the number is below or above (without using the "fill color" icon).  Is there a formula for that?  Thank you Configuration: Windows 7 / Firefox 5.0.1

chossette9 · Accepted Answer

Hello,  since you sent us your spreadsheet in 2007, I assume you are using that version. So, it should be easy to explain. Just use conditional formatting, nothing more  1°) Select the range on which you want to apply your colors  2°) Home tab / Style sub-tab, click on 'Conditional Formatting' -> Highlight Cell Rules -> Greater Than...  3°) Change the value in the left box (here 180). In the dropdown list, choose custom format, and set the format you want.  4°) Repeat steps 2 and 3 this time with 'Less Than...', specifying 150.  5°) Repeat steps 2 and 3 with 'Between...', specifying 150 and 180.  Best regards. -- That guy wasn't bright, because he was foolish.

dna.factory · Answer

conditional formatting. available by default in the latest versions of Excel. https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f?redirectsourcepath=%252ffr-fr%252farticle%252fajouter-modifier-ou-effacer-des-mises-en-forme-conditionnelles-8a1cc355-b113-41b7-a483-58460332a1af&ui=en-us&rs=en-us&ad=us#BMformat_all_cells_by_using_a_two-color  And there is absolutely no need for VBA or other complicated stuff Stop failing the Turing test!

Mike-31 · Answer

Hi, following the explanations from dna.factory, the formula that will not be given to you is =AND(A1>="a";A1<="c") if your conditional formatting needs to apply to a range of cells, start by highlighting the range for example from B2 to B20 the formula will be =AND(B2>="a";B2<="c") these two formulas should help you understand -- A+ Mike-31 A period of failure is an ideal time to sow the seeds of knowledge.

mariang · Answer

thank you dna.factoryit's great...except that I can't tell it that if the number is between 150 and 180 the color will be green, otherwise, it will be gray.I will keep looking...thank you

mariang · Answer

ooops !  thank you mike-31, I hadn't seen your reply  I'll apply it and keep you updated

Mike-31 · Answer

Hi,  to respond to your last post, the formula is  =AND(A2>=150;A2

mariang · Answer

Well, here’s what I wrote that is wrong (error message)  I obviously followed my logic to "me"...  I made cell D2 turn green if the number is between 150 and 180 and I named it  Then I took cell F1 to which I created a new rule so that numbers outside of 150 and 180 turn the cell gray, and I named it as well and so, since I created it, the cell is gray (logical) when I would like it to be "colorless". But it's okay.  I also created a "cell style" but I don't know how to bring it into my formula  So, in the cell where the number should be entered, I wrote this:  with If =IF(B2>=150;B2

mariang · Answer

yes, and I still have this circular reference problem.

mariang · Answer

Thank you Pijaku for clarifying this, as I had noticed it. As soon as I entered the number, the formula disappeared. And it's quite logical, but I wrote my comment before doing what you just mentioned. But it's not working either. The cell doesn't turn green or gray depending on the number entered.

chossette9 · Answer

Hello,  to make it clear for everyone, could you provide an example of what you want to do in an Excel file, go to the website cijoint.fr and generate a link, which you will then copy into a response to this message.  So, we will see more quickly what to do to help you.  Best regards. -- This guy wasn't particularly bright, as he was foolish.

mariang · Answer

ok  here is the file  http://www.cijoint.fr/cjlink.php?file=cj201108/cijNNWZXkj.xlsx  after making mistakes and trying to understand, this time, I created a group of cells that turns green when the number is correct.  however, I can't get the color to change and turn gray if the number is wrong.  I put a formula in it, but it's not correct (of course)  I hope my Excel file is understandable.  thank you for your patience.

mariang · Answer

Hello  I saved it in 2003 format. I hope that will work. I just bought this computer and it doesn't offer me the 2007 version! It's ridiculous!  http://www.cijoint.fr/cjlink.php?file=cj201108/cijp20yBlh.xls  I hope it will still be understandable  Thank you

mariang · Answer

ha, that reassures me!  I thought it was coming from my end because I had trouble setting it up  well, let’s hope it works this time…  http://cjoint.com/data3/3HsrT6iuXPy.htm

pijaku · Answer

Hello, I've finally understood!! I must say you really confused me... The formulas we've been given from the start should not be placed in your spreadsheet but in the conditional formatting!!! Here is your example select your table and check the 3 conditional formatting conditions... -- Best regards, Franck P

mariang · Answer

It's awesome, fantastic, exactly what I wanted...  I didn't understand that you could add as many rules as you wanted to the same cells....  HUGE THANK YOU

Fill a cell with a color in excel

15 answers

Texture issues in enshrouded

Set up 2 computers on 1 cleaner account

Lost tnt channels (via antenna)

Read a facebook video saved as a folder

Turn off

Tutorial: how to fix a pc stuck on a blue screen

My printer won't connect to my pc anymore

Problem with open office spreadsheet

Unblock the thomson thb330 blu-ray/dvd player

Reading, photo or text sharing