Oct 27 2003, 04:52 PM
How would I go about doing something like that, that if the cell value is <=1 then let the cell color be red...
Oct 27 2003, 05:07 PM
Select your range of cells.
Go to format/conditional formatting.
Change your operator to greater than or equal to then enter 1 in then next box over.
Click on format, patterns tab and select your desired color.
Oct 27 2003, 05:08 PM
Try: Format-Conditional Formatting... Cell Value is greater than: x
Where x is your numero.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here