conditional colour of cell
"JW" wrote:
Format--Conditional Formatting
"Cells Value Is" - "Greater than or equal to" - whatever your number
Click on the Format button and make any changes you desire.
To add a second condition, click the Add button.
You are limited to 3 conditions.
Thanks, simple once you know.
Dutchy wrote:
How do i get a cell to be particular colour if sum in cell = than a number
and if not, then assign another colour. New to this so any help appreciated.
|