Is there a way to change the worksheet color based on a calculation. Please help.
**** Prem,
Some links for your reference.
Highlight table with discrete measure for colour
Highlight a row based on a parameter
With more detailed requirements, some sample data or a sample workbook, more precise advice may be possible.
Regards.