i wnt to give an statment in color coded way. say that i have marks in A colom. i wnt to give OK in green if Marks are heighere than 80. if i type =IF(A1>80, "OK") in fomula bar ,OK will apear in Black. how to show it with color redhow can i do so.
2006-08-07 07:54:51 · 3 answers · asked by Nalin S 2 in Computers & Internet ➔ Software
This is called "Conditional Formatting". Select cell A1 type in the word "Test". Select cell A1 and go to the Excel menu and select "Format" then "Conditonal Formatting..." you will see the words "Cell Value is" select this "drop-down" list and select "Formula is" in the blank box to the right type in the formula =A1>80 then click the "Format" button underneath "Color:" select the green color.
Now click the "Add>>" button to add another condition. Select "Formula is" again, this time type in blank box =A1<40, format font as "Black", . Click "OK".
2006-08-07 08:06:57 · answer #1 · answered by onenutnick 2 · 0⤊ 0⤋
Use Conditional Formatting.
Click FORMAT - Conditional Formatting. Follow the instructions.
2006-08-07 07:58:21 · answer #2 · answered by Marvinator 7 · 0⤊ 0⤋
That is called conditional formatting.
Go to Format> Conditional Formatting
2006-08-07 07:58:05 · answer #3 · answered by redheadedtess 2 · 0⤊ 0⤋