| Topic List |
Page List:
1 |
|---|---|
|
Hexenherz 01/15/21 12:45:54 PM #1: |
Terrible topic title explanation, but long story short...
There are requirements that are by Calendar Year and so I'm trying to figure out if there's an easy way to format the cell so that if the training is from 1 Jan to 31 Dec of the current year it's green and anything else is red. Alternatively I guess I could just manually delete anything that's from the previous year >_> --- FFXIV: Lucius Hexenseele (Brynhildr) | RS3: UltimaSuende . 99 WC/Fish/Cook/Fletch/Div/Mining/Smithing/Thieving/Crafting/RC https://letterboxd.com/BMovieBro/ ... Copied to Clipboard!
|
|
Rathinor 01/15/21 12:48:04 PM #2: |
Conditional formatting. Then make a rule that cells between those two dates are green else red.
... Copied to Clipboard!
|
|
Hexenherz 01/15/21 12:53:48 PM #3: |
Rathinor posted...
Conditional formatting. Then make a rule that cells between those two dates are green else red.Is it possible to have it automatically update when the calendar year rolls over though? Or would you have to manually change the year ? --- FFXIV: Lucius Hexenseele (Brynhildr) | RS3: UltimaSuende . 99 WC/Fish/Cook/Fletch/Div/Mining/Smithing/Thieving/Crafting/RC https://letterboxd.com/BMovieBro/ ... Copied to Clipboard!
|
|
AzurexNightmare 01/15/21 12:55:46 PM #4: |
Excel is shit
--- Latest Game Completed 100% Resident Evil VII ... Copied to Clipboard!
|
|
Laserion 01/15/21 12:58:48 PM #5: |
Something along the lines of "if [year in cell] = [year in TODAY ()], make it green". You'll probably have to extract the year from both.
--- There is no "would of", "should of" or "could of". There is "would've", "should've" and "could've". ... Copied to Clipboard!
|
|
Woodger 01/15/21 12:59:16 PM #6: |
Could try =YEAR(A1)=YEAR(TODAY())
with A1 replaced with the first cell in the range. ... Copied to Clipboard!
|
| Topic List |
Page List:
1 |