Want to create a macro or a function for the following. Ex. When I i
cell A1 write OK I want the row to be formatted with pattern green. I
i write NOT OK I want the row to be formatted in a another color. I a
not sure this is possible without pressing a macro button. Please help

--
Message posted from http://www.ExcelForum.com

Hi Little V,

Look at the built-in Conditional Formatting feature.

Select the cells that are to change according to the content of A1, then
try:

Format | Conditional Formatting | In Condition1 box select 'Formula Is' |
Select next box and type: $A$1="OK" | Hit the Format key | Select the
Patterns tab | Select a suitable color | OK | Add

Repeat all the previous steps, replacing "OK" with your alternative "Not OK"

Finally, click OK to confirm all your choices.

If you need further help with conditional formatting, see Debra Dalgleish's
excellent tutorial at:

http://www.contextures.com/xlCondFormat01.html


---
Regards,
Norman



"LittleV " wrote in message
...
Want to create a macro or a function for the following. Ex. When I in
cell A1 write OK I want the row to be formatted with pattern green. If
i write NOT OK I want the row to be formatted in a another color. I am
not sure this is possible without pressing a macro button. Please help!


---
Message posted from http://www.ExcelForum.com/

Hi !

Thanks to both Zantor and Norman! This was exactly what I needed!!

Best reg
Jo

--
Message posted from http://www.ExcelForum.com

Hi LittleV ,

Attached is a file named FormatRows.xls, I think it's what you ar
looking for.

regards
Zanto

Attachment filename: formatrows.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=69210
--
Message posted from http://www.ExcelForum.com