vlus
Technical User
- Sep 26, 2002
- 45
I didn't think this would be unusual but I can't find any documentation on how to perform this task in Excel2K, if it is even do-able...
what I am trying to achieve is a basic if, then deal, where IF TRUE the background color of the target cell can be set to draw attention to the warning text that will also appear in that cell.
To get a practical idea of what I am trying to accomplish...
Consider this:
=IF (A1 > (A2*85%), ALERT 85% Capacity, IF (A2*70%),CAUTION 70% Capacity))
Where the 85% alert should be a RED cell background, the 70% caution should be a yellow background, otherwise nothing (white).
Thank you in advance for any help.
Vic
what I am trying to achieve is a basic if, then deal, where IF TRUE the background color of the target cell can be set to draw attention to the warning text that will also appear in that cell.
To get a practical idea of what I am trying to accomplish...
Consider this:
=IF (A1 > (A2*85%), ALERT 85% Capacity, IF (A2*70%),CAUTION 70% Capacity))
Where the 85% alert should be a RED cell background, the 70% caution should be a yellow background, otherwise nothing (white).
Thank you in advance for any help.
Vic
