Conditional Formatting
 

Hello,

I would like to conditional format a row of cells (example b1:b15) if b1
reads anything but a certain word.

For example I would the format to work for any entry except if the cell said
€˜Future Use.€�

Any suggestions?

Thanks

including cell b1?
for b1 formatconditional format,cell value is equal to from drop down
box,in the next box type ="test",for the rest of the row,formatconditional
format click down formula is,in the next box type =B$1="test",with all the
cells you want to format highlighted
--
paul
remove nospam for email addy!



"Jim" wrote:

Hello,

I would like to conditional format a row of cells (example b1:b15) if b1
reads anything but a certain word.

For example I would the format to work for any entry except if the cell said
€˜Future Use.€�

Any suggestions?

Thanks