Go | New | Find | Notify | Tools | Reply | |
| Unapologetic Old School Curmudgeon  |
Is there a way to have an if-then statement, where I could say for cell C, if cell B is more than cell A then make cell C green? Don't weep for the stupid, or you will be crying all day | ||
|
Member |
At the most basic level: example: using Cell C1 =if(Ac>B2,true,false) C2 would either have a value of "TRUE" or "FALSE" Then select the column with the TRUE/FALSE and go into Conditional Formatting and have it highlight the cells that contain "TRUE" or "FALSE", the Format cells that contain the text: you would enter either TRUE or FALSE.    https://support.office.com/en-...13-9ecb-f1951ff89d7f ...let him who has no sword sell his robe and buy one. Luke 22:35-36 NAV "Behold, I send you out as sheep in the midst of wolves; so be shrewd as serpents and innocent as doves." Matthew 10:16 NASV | |||
|
Member |
Yes ... Excel 2016 for Windows Home > Conditional Formatting > Highlight Cell Rules > Equal To ... enter the cell C word/text format, then the desired formatting. Works well if Cell C has the words like Open, Closed, Paid, something like that. We are all born ignorant, but one must work hard to remain stupid." ~ Benjamin Franklin. "If anyone in this country doesn't minimise their tax, they want their head read, because as a government, you are not spending it that well, that we should be donating extra...: Kerry Packer SIGForum: the island of reality in an ocean of diarrhoea. | |||
|
| Member |
Yes, Equal To would be better to use than "Contains..".
...let him who has no sword sell his robe and buy one. Luke 22:35-36 NAV "Behold, I send you out as sheep in the midst of wolves; so be shrewd as serpents and innocent as doves." Matthew 10:16 NASV | |||
|
| My common sense is tingling  |
Highlight cell C1 (or C column) Conditional formatting > new rule > Use a formula Formula: =$B1>$A1 Then select the cell fill from the format button “You can have peace. Or you can have freedom. Don't ever count on having both at once.” - Robert Heinlein | |||
|
His Royal Hiney |
This would be the most efficient and effective method. "It did not really matter what we expected from life, but rather what life expected from us. We needed to stop asking about the meaning of life, and instead to think of ourselves as those who were being questioned by life – daily and hourly. Our answer must consist not in talk and meditation, but in right action and in right conduct. Life ultimately means taking the responsibility to find the right answer to its problems and to fulfill the tasks which it constantly sets for each individual." Viktor Frankl, Man's Search for Meaning, 1946. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
|
© SIGforum 2024