Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
excel spreadsheet conditional formatting?
I want to make a column and its cells turn from green to yellow to red. Say for example todays date and 45 days from now I want it to turn yellow and 45 days after that I would like it to turn red. Any help on the matter would be awesome.
3 Answers
- IXL@XLLv 71 decade agoFavorite Answer
Date in cell A1. Format cell as green (default) Conditional format Formula is (conditional 1) =A1+45. Format cell yellow. Condition 2 Formula is =A1+90 Format as red
- tapleyLv 44 years ago
On homestead tab, conditional formatting. decide for the column containing the values. decide for the conditional formatting, new rule. If the values are numbers in reality persist with format cells according to their values and choose 3 colour. you should edit the colour scheme . in the event that they contain text textile textile you will need use the backside determination 'format cells according to a formula' then write your formula '="section a million" then decide for the fromat for font, fill, etc and attempt this for each of your components
- 1 decade ago
The link below will take you to FGCU's Excel tutorial page. It will probably answer this and any other questions you may have in the future.
