Conditional Formatting

J

Jim

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
 
P

paul

including cell b1?
for b1 format>conditional format,cell value is equal to from drop down
box,in the next box type ="test",for the rest of the row,format>conditional
format click down formula is,in the next box type =B$1="test",with all the
cells you want to format highlighted
 
Top