Using conditional formatting in Excel 2007
For Example:
A B C D E
1 Text Text Text Text 0
2 Text Text Text Text 0
3 Hi-Text Hi-Text Hi-Text Hi-Text 1
4 Text Text Text Text 0
5 Hi-Text Hi-Text Hi-Text Hi-Text 1
I want to format all cells A1:D5 to be formatted to highlight if the Cell in
column E = 1.
|