Hi all! is that possible to use formula and determine the color at the same time without VBA? For example, Column B has following formula "=IF(MONTH(A1)+1=MONTH(TODAY()),"50","")", but let's say that row 2 and 3 is yellow, so I need the formula to show double of 50 (100), but still based on the formula that catches only last month entries.
<tbody>
</tbody>
Thanks
A | B | ||
1 |
<tbody> </tbody> | 50 | |
2 |
<tbody> </tbody> | 100 | |
3 |
<tbody> </tbody> | 100 | |
4 | |||
5 | |||
6 |
<tbody> </tbody> | 50 | |
7 |
<tbody> </tbody> |
<tbody>
</tbody>
Thanks