Conditional Formatting
FormatConditional Formatting under this you can define a formula referring
to the cell H5="open" and define the conditional formats. You can specify
upto 3 different conditions and you can also specify them within a formula,
such as an if function
"Kimberly5590" wrote:
Hi,
I am trying to write a condition if one cell meets the condition (Example H5
= OPEN) then turn cells H1 through O1 to red (Color fill)
If H5 = Closed then turn Cells H1 through O1 to Green
Is this something I can do in Excel?
Any help would be greatly appreciated.
Thanks
|