Patterns

[LittleV]

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

 

[Norman Jones]

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

 

[zantor]

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

 

[LittleV]

Hi !

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

Best reg
Jo